Multiple SQL statements

[BMarcus926]

I just downloaded the trial version and am comparing it to my longtime favorite, SQL Navigator. So far, favorably -- except for one thing: is there a way to allow multiple SQL statements in a single window? This helps you develop a SQL script, as opposed to a PL/SQL program. Not a showstopper but something I am accustomed to doing...

 

[MarkP]

Hi BMarcus926,

What about PL/SQL Developer's 'SQL Window'? It allows multiple DML statements to be entered, separated by ';'s.

The SQL Window tab of the Preferences can be used to refine its configuration.

Regards, Mark.

 

[Clouds]

End each query with a semicolon (

When executing, the query where the cursor currently is, will be executed.
This query will also be highlighted then.

hth

[This message has been edited by Clouds (edited 05 September 2003).]

 

[Marco Kalter]

Additionally, the Command Window allows you to execute multiple SQL statements, PL/SQL Blocks and SQL*Plus commands at once. The Command Window is designed for batch functionality and SQL*Plus compatibility.

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

 

[news0reader]

I just came across this thread...and while the responses are useful I still don't see how to do what I suspect the original poster was after: have multiple statements in a window and have *all* of them executed in batch. Something like:

select 1 from dual;
select 2 from dual;

When executed I'd like to get 2 resultsets, either in the same output display (as in Embarcadero) or in separate output displays. Is this possible?

Thanx

 

[Marco Kalter]

This is only possible in the Command Window. The SQL Window will only execute one statement at a time.