Multiple results in SQL Window?

[Leigh Kendall]

Is there a trick to run more than one sql statement in the SQL window and see three grids of results at the same time?

For example:
select * from table1
select * from table2
select * from table3
======================================
table1 results grid
table2 results grid
table3 results grid

I can do this in SQL Server's Query Analyzer and was trying to do it in PL/SQL Developer to no avail.

Thanks...

------------------
Leigh Kendall

 

[Marco Kalter]

You cannot run these statements simultaneously. They can only be run simultaneously in the Command Window.

If you separate the 3 statements with a semi-colon, and enable the preference "AutoSelect Statement" (Tools > Preferences > SQL Window), then the SQL Window will automatically select the current statement where the cursor is located.

------------------
Marco Kalter
Allround Automations

 

[Leigh Kendall]

Right, command window.

Thanks!