
26
|
Toad Pocket Reference for Oracle
displays the column names, datatypes, and data lengths of all
of the columns that will be returned by the query.
If you misspell a column name, or if that column no longer
exists, the query will not parse completely but will stop at the
invalid column name.
Use substitution variables
Toad opens the Variables input window when you execute a
statement using bind variables in the SQL Editor. When you
execute the following:
SELECT * FROM EMPLOYEE WHERE employee_id = :EMPID
you will be prompted to select the datatype and enter your
value before clicking OK to continue execution. Toggling
Scan statements for bound variables before execution in View
➝ Options ➝ SQL Editor ➝ General will disable this.
Cancel running statement
Toad lets you cancel long-running queries. When a state-
ment such as the following is executed:
SELECT * FROM DBA_OBJECTS ORDER BY object_id
the Cancel button at the right end of the Execute function on
the SQL Edit toolbar is active as long as the query can be ter-
minated.
Using Extended Features
This section briefly describes some more advanced features
available from the SQL Editor.
Use the Script Debugger
This extended Toad feature is available only in Toad for Ora-
cle editions that include debugging functionality. The Script
Debugger is an extension to the SQL Editor that you can use
to debug SQL scripts. You can load multiple scripts; each