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?

1 comment
Comment actions Permalink

Take a look at User Parameters they allows to run parameterized statements https://www.jetbrains.com/help/datagrip/settings-tools-database-user-parameters.html

0

Please sign in to leave a comment.