
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