Multiple Queries in PL/SQL Developer

[seequal]

Hello,

I am a TSQL Developer and am new to PL/SQL and PL/SQL Developer.

I would like to know whether it is possible to run two queries at the same time in one window. In SQL Server Query Analyser you could do the following for example:-

select top 1 * from table1
go
select top 1 * from table2


Thanks

 

[BJCooperIT]

Not that I am aware of. Have you asked this in the support forum?

You can run two queries simultaneously in separate windows.

[sup]Beware of false knowledge; it is more dangerous than ignorance.[/sup][sup] ~George Bernard Shaw[/sup]
Consultant Developer/Analyst Oracle, Forms, Reports & PL/SQL (Windows)
My website: www.EmuProductsPlus.com

 

[seequal]

Thanks BJ,

There is a way of doing this having looked at the support forum, simply:-

select * from table1 where rownum < 2
/
select * from table2 where rownum < 2
/

This will return the results to seperate tabs, but allows multiple queries to be executed at the same time.

Cheers

 

[BJCooperIT]

That works in a command window; however, if you run it in an SQL window you will only see the results of last query.

 

[seequal]

I've come across the same problem. I am a T-SQL programmer and have just moved into PL/SQL using PL/SQL Developer.

If you are using version 6.0.6.946 (like I am), then indeed this is only possible in a command window.

However, if you are using version 7.1 (possibly 7.0) then this is available in an SQL window also (I have just downloaded the 30 trial for 7.1)

Cheers