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?

0
1 comment

Please sign in to leave a comment.