Installation
System Requirements
Install Toad
Specify App Data Directory Location
Read-Only Installation
Install Toad Silently
Install Toad on Citrix Systems
Upgrade Toad
Upgrade Automation Scripts
Files Migrated During Upgrades
Uninstall Toad
Configure Toad Layouts
Create Connections
Understand Toad Connections
Create Access Connections
Create BusinessObjects Connections
Configure DB2 Client Connections
Configure DB2 LDAP Support
Create DB2 Connections
Create Excel Connections
Create SharePoint Connections
Create Google Analytics Connections
Create Hive Connections
Create Intelligence Central Connections
Create MySQL Connections
Create ODBC Connections
Configure Oracle LDAP Support
Create Oracle Connections
Create Oracle BI Connections
Create PostgreSQL ODBC Connections
Create Salesforce Connections
Create Snowflake Connections
Create SQL Server Connections
Create SSAS Connections
Create SAP Connections
Create SAP HANA Connection
Create Teradata Connections
Troubleshoot Connections
Troubleshoot Access Issues
Troubleshoot Hive Issues
Troubleshoot Excel Issues
Troubleshoot DB2 LUW Issues
Troubleshoot DB2 z/OS Issues
Troubleshoot Informix Issues
Troubleshoot MySQL Issues
Troubleshoot Oracle Issues
Troubleshoot SQL Server Issues
Troubleshoot Sybase ASE Issues
Configure Version Control
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.