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
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 ...
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