Bernhard S
Member³
Hi,
there's another annoyance on an sql window with multiple selects all separated by semicolon.
When you press F8 and have the option "Autoselect statement" selected, it does what expected, selects the whole statment and executes the query.
However if you happen to be interested then in the execution plan for the same sql and just press F5, pl/sql developer complains about the semicolon of the statement at the end. Only when you select the statment without the semicolon the F5 - explain plan works.
Best regards,
Berny
there's another annoyance on an sql window with multiple selects all separated by semicolon.
When you press F8 and have the option "Autoselect statement" selected, it does what expected, selects the whole statment and executes the query.
However if you happen to be interested then in the execution plan for the same sql and just press F5, pl/sql developer complains about the semicolon of the statement at the end. Only when you select the statment without the semicolon the F5 - explain plan works.
Best regards,
Berny