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;

   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

请先登录再写评论。