Skip to Main Content
Toad Pocket Reference for Oracle, 2nd Edition
book

Toad Pocket Reference for Oracle, 2nd Edition

by Jeff Smith, Patrick McGrath, Bert Scalzo
May 2005
Intermediate to advanced content levelIntermediate to advanced
130 pages
4h 31m
English
O'Reilly Media, Inc.
Content preview from Toad Pocket Reference for Oracle, 2nd Edition
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
SQL Editor ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle PL/SQL Language Pocket Reference, 5th Edition

Oracle PL/SQL Language Pocket Reference, 5th Edition

Steven Feuerstein, Bill Pribyl, Chip Dawes
Oracle RMAN 11g Backup and Recovery

Oracle RMAN 11g Backup and Recovery

Robert Freeman, Matthew Hart
Oracle Database 11g A Beginner's Guide

Oracle Database 11g A Beginner's Guide

Ian Abramson, Michael Abbey, Michael Corey

Publisher Resources

ISBN: 9780596529079