
SQL Editor
|
23
Make the appropriate entries in View ➝ Options ➝ Team
Coding so Toad recognizes your installed version control
software. You will need to provide Toad with your default
working directory. Set the appropriate options for checkin
and checkout prompts, and for comments when new files are
added. Each file will open in its own tab in the SQL Editor.
Executing Statements
Toad allows you to execute statements in several different
ways. You can execute statements one at a time, execute all
of the content in the SQL Editor at once, or execute the con-
tent in the SQL Editor as a script.
Execute a single statement
The SQL Editor provides functions that allow you to exe-
cute single SQL statements. This may be a standalone state-
ment, a highlighted statement, or a statement executed as a
script. The tabbed format includes both the Editing panel
and the Results panel so that each tab acts like a standalone
SQL Editor.
The SQL Editor can handle both query statements and DDL
statements. For example, enter the following statement on
the first SQL Editor tab:
SELECT * FROM tablename WHERE rownum < 50
Toad does not require semicolons to terminate SQL statements.
There are several other ways to execute a SQL statement.
You can select SQL Editor
➝ Execute All SQL, click on the
Execute All SQL button on the SQL Edit toolbar, or press
F9. Your execution results will display on the Data tab in the
Results panel ...