Max queries run in a single SQL Query window?

[ckubitsc]

If I run multiple queries from the SQL Query window the results for each query appear in separate tabs. How many queries can I run at once (or, phrased differently, how many tabs can I create at once)?

As background - I've written a query to generate a set of queries. If I select all the resulting queries to run I'll be running over 1,000 queries. It's not pretty but it's what I need to run. Do I need to break these into multiple windows (or sessions) or can I just start them all together and go home with the expectation that they'll either be done or still running when I come back?

Thanks.

 

[Marco Kalter]

You should probably run such a script in the Command Window. The SQL Window is an interactive tool, whereas the Command Window is a batch tool.

 

[ckubitsc]

Thanks for the interesting suggestion. I eventually want the results copied to Excel - one query per tab. Can I do that from the Command Window?

 

[Marco Kalter]

No, for Excel export functionality you would need to use the SQL Window.

 

[ckubitsc]

That brings me back to the original question then. How many queries (Ctrl-A) could I run in a single SQL Query window? Is there a limit?

 

[Marco Kalter]

There is no limit in PL/SQL Developer. There might be a limit in resource usage of the PC or in Windows though.