0 Replies Latest reply on Feb 21, 2018 3:44 PM by virooz

    SQL worksheet explain plan not working

    virooz

      Hi guys,

      this discussion is about parser and delimiters.

       

      Simple example.

      Copy and paste this to an empty SQLDeveloper SQLWorksheet (old version 4.1.3):

       

      create table t1(a varchar2(1))

      /

      drop table t1

      /

      select * from dual

      /

       

      Placing the cursor on each expression and press F10:

      - create table statement explain plan

      - ORA-00905

      - select statement explain plan

       

      OK, no problems in 4.1.3

       

      One more time in 17.4:

      - create table statement explain plan

      - ORA-00933

      - ORA-00933 [even when select statement fully highlighted with selection]

       

      However changing delimiter after drop from / to ; fixes the situation.

       

      Is there any way to make explain plan work correctly with / delimiter or it's a bug?

      Unfortunately I have no access to MOS to check this.

       

      Thank you!