Chat now with support
Chat with Support

Toad for Oracle 12.11 - 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

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

Work with Code > Execute Statements and Scripts > 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.

 

Save Statements (SQL Recall)

Work with Code

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.

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating