Run 2 queries at the same time on Oracle SQL Developer?

oracle oracle10g oracle-sqldeveloper
Sologoub picture Sologoub · Jul 13, 2010 · Viewed 57.1k times · Source

I need to retrieve quite a bit of data from our oracle DB and to do so I need to run 20+ queries. Is there any way to run more than one query at a time on the same connection?

I tried using / to separate the queries, but that simply opens multiple tabs and queries still run sequentially, although I don't have to start them one by one.

Answer

wds picture wds · Oct 30, 2012

Pressing ctrl+shift+N will open a new unshared worksheet that can run queries in parallel. In that case you have to paste a query in each tab and run them manually though, but it is handy when just testing a few queries.

Related questions

How to see refcursor result/output in Oracle SQL Developer?

Possible Duplicate: Best way/tool to get the results from an oracle package procedure Oracle SQL Developer: Show REFCURSOR Results in Grid? I am new to Oracle SQL Developer. I am using Oracle SQL Developer Version 3.0. I was trying to …

Read More
How can I keep Oracle SQL Developer from closing the DB connection?

Is there any way to keep Oracle SQL Developer from closing my DB connections, or to increase the timeout? Sometimes during a long-running query SQL Dev will just close the connection, leaving my query running on the server but me …

Read More
Need to count records and group count by date on oracle db using sql developer

I have a table like the following ID created sent type ----------------------------------------------------- 0001463583000051783 31-JUL-12 1 270 0081289563000051788 01-AUG-12 1 270 0081289563000051792 01-AUG-12 1 270 0081289563000051791 01-AUG-12 1 270 0081289563000051806 01-AUG-12 1 270 0001421999000051824 06-AUG-12 1 270 0001421999000051826 06-AUG-12 1 270 0001464485000051828 06-AUG-12 1 270 0082162128000051862 09-AUG-12 2 278 0082162128000051861 09-AUG-12 2 278 0022409222082910259 09-AUG-12 3 278 I would like to have the following for output created Count --------------------- 31-JUL-12 1 01-AUG-12 4 06-AUG-12 3 09-AUG-12 3 How …

Read More