Introduction
Connect
Create Amazon Redshift Connections
Create ODBC Connections
Create Oracle Connections
Create Snowflake Connections
Create SQL Server Connections
Create SharePoint Connections
Understand Toad Connections
Troubleshoot SQL Server Connections
Understand
Determine the Best Method to Locate Objects
Object Explorer
Filter Databases and Objects
Understand a Table Using the Database Explorer
Search for Objects
Create an Database Diagram to Use as a Query Template
Browse Data in Related Tables
Query
Tutorial: Build a Query Visually
Create Cross-Connection Queries
Reverse Engineer Queries
Build a Subquery
Edit SQL
Editor Shortcut Keys
View Result Sets
Compare Differences in Data
Export Data with One Click Export
Share Excel Linked Queries
Automate
Execute SQL
To execute SQL
- Use one of the following methods to execute SQL:
- To execute all statements, in order, one at a time, click
or press F5.
- To execute the current statement, click
or press F9.
- To execute all statements, in order, one at a time, click
To execute the code within a code Region
- To execute a single code region, right-click within the region and select Select Current Region. Then press F5. See Set Code Regions for more information about Regions.
Retrieving Data
After retrieving 2500 rows, Toad saves data to disk by creating a TMP (.tmp) file. This allows Toad to retrieve as many rows as your disk's free space can accommodate. These TMP files are deleted when Toad closes.
When executing a query, if there is not sufficient free space, Toad displays an informative message and terminates execution.
Tips:
- You can execute SQL against multiple connections simultaneously. See Group Execution of Scripts for more information.
- You can view the progress of statements executing in the background in a progress bar located in the status bar. Click the progress bar to open the Background Processes window to cancel execution. See Stop Background Processes for more information.