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.

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 ?

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.

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

>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.