How to execute more than one SQL query statement at one time. (4225624)

How to execute multiple SQL query statements at the same time or simultaneously in the Editor? How to free up Toad and be able to do other activities while it's executing a long running query? 

There are  two ways to execute multiple SQL statements using the SQL Editor.

1. If you would like to execute multiple queries in ONE SQL Editor window, simply click the "Yellow Lightning Bolt" icon from the toolbar or hit the F5 key. This will execute all of the SQL statements listed in the editor.

OR

2. If you are trying to execute queries in threads, you will need to enable the "Execute queries in threads (Creates separate session)" option. This option can be found by going to View  | Toad Options | Oracle | Transactions. When you enable this option, you will need to open a new SQL Editor window for the changes to take effect. When this option is enabled, you can have multiple SQL Editor windows executing SQL statements. This option also allows you to do other tasks in Toad while your query is running. You also have the ability to cancel your running queries with this option.

Another option is to run any SQL scripts using the Quest Script Runner (QSR):

1. Load or write your SQL statement or script in the editor.
2. Go to Editor | Execute SQL via QSR in the main menu.
3. This will pop up the Quest Script Runner in a new window. Run the script or SQL from the QSR.

Note: If the script takes time to execute, this will give you the freedom to switch to other applications while it is still running.