Chat now with support
Chat with Support

Toad for Oracle 17.1 - Getting Started Guide

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

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

 

Execute Single Statements

Note: To cancel the execution, click in the Execute toolbar.

Execute Scripts in the Editor

Caution: If any changes have been made, the script in the current window is automatically saved, and then executed as a script.

Note: To cancel the execution, click in the Execute toolbar.

Execute SQL with SQL*Plus

You can open a DOS box to execute the contents of the Editor using SQL*Plus.

Important:

SQL*Plus does not support Unicode.

Toad does not support all SQL*Plus commands. See SQL*Plus Commands in the online help for more information.

Note: If you change data in the script session, the changes will not reflect in Toad until you commit the changes in the script session. Also, any session control statements executed in the script session (such as ALTER SESSION) are not visible to the Toad session.

To access MS DOS for SQL*Plus

From the Editor menu, select Execute SQL via SQL*Plus.

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating