Multiple statements in Explain Plan Window

  • Thread starter Thread starter he
  • Start date Start date

he

Member²
Hello,

if you have multiple statements in the SQL Window and then press F5 (Explain Plan Window), all statements are taken into the Explain Plan Window. Then comes an ORA-00911 error. How can I get only the selected statement in the Explain Plan Window?

Thanks, he
 
If you select a statement in the SQL Window and press F5, only the selected statement will be taken to the Plan Window. If you do not make a section, the whole script will be taken to the Plan Window.
 
I believe there has already been a request to make F5 work as F8 when "autoselect statement" is checked. That'd be really welcome. ;)
 
Thanks Gustavo, that's what I ment.

Marco, would you please take this on the list of requested features?
 
Back
Top