How to make Oracle SQL syntax with variables work in IntelliJ database query console


Query console do not understand Oracle SQL dialect. How do you make syntax like this:

   variable personname varchar2;

   variable mobilenumber number;


       :personname := 'John';

      :mobilenumber := 1000;



   insert into tablename (col1, col2) values(:personname, :mobilenumber);

   // more inserts, updates, and more with use of variables


work from the query console?

1 comment
Comment actions Permalink

Take a look at User Parameters they allows to run parameterized statements


Please sign in to leave a comment.