Chat now with support
Chat with Support

Toad for Oracle 12.12 - Getting Started Guide

Table of Contents Welcome to Toad Toad Resources Required Privileges Create and Manage Database Connections Editor Basics Schema Browser Basics Data Grid Basics Work with Data Work with Database Objects Work with Code
Write Statements and Scripts Work with the Query Builder Execute Statements and Scripts Save Statements (SQL Recall) Work with PL/SQL Objects Debug Analyze Code Optimize SQL
Customize your Toad Environment Use Other Quest Software Products with Toad

Use the Generated Query

  • Select a query and press CTRL+C
  • Click the Send text to clipboard button
  • Select the query, right-click and select Copy

Saving Toad Query Results

Any of Toad's window query results can be saved to the Windows Clipboard or to a file by the procedure below. Some dialog boxes do NOT have a Copy to Clipboard or Save to Disk function. This duplicates that functionality.

To save query results

  1. Turn on spooled output to disk file: Database | Spool SQL | Spool SQL To File.
  2. Run the desired Toad window (for example, the Schema Differences window) select each desired tab.
  3. From the User Files folder, open DEBUG.SQL.
  4. Copy each SQL into the Editor window.
  5. Run each SQL in the Editor window, substituting hard coded values for the bind parameter variables, or just enter them when prompted in the Variables dialog box.
  6. Save the grid contents to clipboard or disk file, using right-click, Export Dataset.

 

Execute Statements and Scripts

Toad provides an intuitive and efficient way to write, run, and test your SQL and PL/SQL code. Toad supports efficient code management for a single developer or a whole team of developers.

 

About Executing Scripts

Toad provides many different options for you to execute scripts:

If you want to... Review the following:
Execute a script in the Editor

Use Execute as script (F5) in the Editor. Execute Scripts in the Editor

Considerations:

  • Long-running scripts can tie up the Editor.
  • Does not support bind variables and cannot produce editable data. Alternately, you can execute the code as a statement. Execute Single Statements
  • Fetches all matching records at the same time, which may cause it to execute slower and use more resources.

Execute a long-running script without tying up Toad (execute a script outside of Toad)

Use Toad Script Runner for scripts that may take a long time to execute or to execute a script in an external application.

See Execute Scripts with Toad Script Runner in the online help for more information.

Considerations:

  • Compared to executing a script in Toad, Toad Script Runner does not offer all of the Editor's features
  • You can also use SQL*Plus to externally execute scripts. SQL*Plus does not have data grids or other Toad features, and it does not support Unicode. Execute SQL with SQL*Plus
Execute multiple scripts

You can use the Automation Designer or Script Manager. See the following in the online help for more information:

  • Automation Designer Overview
  • Script Manager Overview
Schedule execution

Create a Toad Action and schedule it to run.

See Schedule Actions and Apps in the online help for more information.

Execute through the command line

Execute scripts or Toad Actions with scripts from the command line. See the following in the online help for more information:

  • Command Line Syntax
  • Execute Actions from the Command Line
  • Automation Designer Overview

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating