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
18
|
Toad Pocket Reference for Oracle
Right Mouse menu
SQL Editor Right Mouse menu provides access to addi-
tional text manipulation, execution trace, and Editor display
functions. Using this menu (shown in Figure 5), you can set
bookmarks for easy navigation through long scripts. You can
also change blocks to all uppercase, lowercase, or initial caps.
Comment Block and UnComment Block functions are avail-
able, as are functions to create PL/SQL’s DBMS_OUTPUT
statements, apply Unix-style file saves, select the different
Oracle optimizer modes (not available in Oracle Database
10g connections), and initiate Oracle’s SQL Trace (TKPROF)
or Toad’s AutoTrace programs in order to gather Oracle exe-
cution statistics. (See the V$ Tables Required page in Toad
Help for the tables needed to access the optimization screens.)
Shortcut Keys
The SQL Editor provides a useful set of shortcut keys, which
are listed in Table 1. Note that these shortcut keys are spe-
cific to the SQL Editor. They are available in both the Edit-
ing panel and the Results panel.
There is a fair amount of shortcut key definition duplication
among the various Toad editors (SQL Editor, Procedure Edi-
tor, and Text Editor). However, there are also significant dif-
ferences. For example, the shortcut F9 executes a statement
in the SQL Editor, but it compiles a stored program in the
Procedure Editor.
Toad allows you to customize shortcut keys
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