SQL Window

[bella]

I'm new to using PL/SQL Developer so I could possibly be making a request for something that already exists.
I previously used SQL Navigator and was able to run multiple SQL statements using SQL editior that would give me the output of each statement in a grid with each result set on a different tab.

Select * from EmployeeTbl;
Select * from ProducerTbl;
I'd get a grid with all the employee info on the first tab and all the producer info on the second tab.

Is this possible in PL/SQL Developer? I haven't been successful with it and I continue to get error: ORA-00911: invalid character
I am aware that I can run multiple statements in the command window to see all the data on one screen but its not as uniform and clean as the grid on the SQL window.

 

[Makker]

Looks like a smart feature to me. But as far as I can see PSD does not support in now.

Regards,
Martien

 

[Marco Kalter]

This has been added for the next release. You will get multiple tabs for the result sets.

Right now you can execute just one single SQL statement at a time (no SQL*Plus commands like "define"). It cannot execute multiple statements separated by semi-colons. However, if you go to Tools > Preferences > SQL Window tab page, you can enable the "AutoSelect Statement" preference. Now the SQL Window will recognize that you have multiple statements in the editor, and will execute (and select) just the one under the cursor.

 

[ScottMattes]

COOL!

 

[Makker]

How are you gonna handle autorefresh? Is then refreshing every sql-statement in the window or is it per statement/grid? May be both (by tagging a grid on or off)?

 

[Marco Kalter]

It will re-execute the whole script.

 

[Makker]

Ok, sounds good! Can become very handy in monitoring several things in the concurrently.

Regards,
Martien

 

[Makker]

Will the same possibility be added to the Reports window? It would be neat to be able to create a report based on several queries, pl/sql-blocks with dbms_output and some custom text in between.
In that case it would be possible to create health-check reports for several purposes for example a standard system-setup.

Regards,
Martien van den Akker.

 

[CTzen]

uber-cool

by the way, it's already November, if I'm not mistaken

 

[Marco Kalter]

@Makker: We have some plans to support multiple queries in the Report window, for purposes of initialization and multiple result sets, but this has not been added for 7.0 yet.

@CTzen: Correct.

 

[bella]

Originally posted by Marco Kalter:
This has been added for the next release. You will get multiple tabs for the result sets.

Right now you can execute just one single SQL statement at a time (no SQL*Plus commands like "define"). It cannot execute multiple statements separated by semi-colons. However, if you go to Tools > Preferences > SQL Window tab page, you can enable the "AutoSelect Statement" preference. Now the SQL Window will recognize that you have multiple statements in the editor, and will execute (and select) just the one under the cursor.

Has this been added to v7.0?

 

[Marco Kalter]

Yes: