Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to generate mutiple Results for multiple SQL SELECT statements

432328Apr 24 2008 — edited Feb 22 2011
I just downloaded SQL Developer 1.5 and play around with it.

On a daily basis, I need run 4 different SELECT statements and dump the output of each SELECT into an CSV file and send to some users. In SQL Navigator, I can select all 4 SELECT statements and execute them at same time. Once all complete, I will see 4 tabs, each represent the output for each SELECT statement. Then I can export output from each tab into a CSV file.

It seems that SQL Developer 1.5 still can't run mutiple SELECT statements and display the output of each statement into a separate "Results" tab so that I can export the data into multiple CSV files easily.

Right now, I have to hightlight each SELECT statement and press F9, then export the output data into CSV.

I wish I can execute 4 SELECT statements all in once on SQL Developer and get all the output data and export 4 times into 4 CSV files.



Thanks!

Kevin
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 22 2011
Added on Apr 24 2008
9 comments
3,738 views