sql window with multiple sql separated by ";" fails with explain plain

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
 
I have added this to the list of enhancement requests. F5 should always work with just the current statement.
 
Back
Top