How to pass 2 sql statement at same time..

[TMoore]

Hi

I wrote this:
select count(1) from test;
select * from test;

developer hang on ';' character. How to solve this problem? Sometimes I have long script whitch can not union select.

 

[MartinSchm]

What you you expect as result of this both queries ?

Two different result panes ?

Why don't you use a second window for the second query ?

 

[ScottMattes]

There is an option under Tools / Preferences / SQL Window called AutoExecute Queries. Check it and when you click Execute PLSD will select the closest query and execute it.

 

[aotte]

The alternative is to execute from the command window, which mimicks SQL*Plus.

 

[TMoore]

>What you you expect as result of this both >queries ?
It is one of the solution. I don't what to use second program window. I have 8 queries, each has 10 - line of code.
> Auto-execute and Auto-select is good and also mark some sql and fire it.

I can write union select but it costs much more cpu time.

How to present this results, maybe it could be represents on each tab. It's great idea.