Search

Saturday, 11 June 2016

How to run multiple queries at once in Toad?

To run multiple queries in Toad at once follow these steps:

1. Open Toad.
2. Go to View -> Toad Options. An Options pop up window will appear.
3. In the left pane click on: Oracle -> Transactions.
4. After clicking on Transactions in the left pane, on the right pane you will see a checkbox with "Execute queries in threads (Creates separate session)" checkbox.
5. By default it is unchecked, check it and click on Apply button on bottom right. Click on OK.

Now the next time you will connect to a database instance you will be able to run separate queries in different tabs without getting the 'Statement Processing' popup.

If the above post was helpful to you then please leave a message in the comments. Thanks.