How to make Oracle SQL syntax with variables work in IntelliJ database query console
Answered
Query console do not understand Oracle SQL dialect. How do you make syntax like this:
variable personname varchar2;
variable mobilenumber number;
BEGIN
:personname := 'John';
:mobilenumber := 1000;
END
insert into tablename (col1, col2) values(:personname, :mobilenumber);
// more inserts, updates, and more with use of variables
work from the query console?
Please sign in to leave a comment.
Take a look at User Parameters they allows to run parameterized statements https://www.jetbrains.com/help/datagrip/settings-tools-database-user-parameters.html