Toad Pocket Reference for Oracle, 2nd Edition

SQL Editor

|

13

Display

The SQL Editor window is composed of a Script Navigation

panel on the left, a tabbed Editing panel, and a multitabbed

Results panel (described later in the “Using the Results

Panel” section). You can toggle a full-screen display of the

SQL Editor as follows:

F2

Toggles a full-screen Editing panel

SHIFT-F2

Toggles a full-screen Results panel

SQL Editor

➝ Right Mouse ➝ SQL Editor Desktop allows

you to choose which Results panel tabs are visible (e.g.,

Query Viewer, Script Output, Script Debugger, Navigator,

Explain Plan, DBMS Output, Data Grid, CodeXpert, and

Auto Trace). You can also hide the Script Navigation panel.

Toolbars and Menus

The SQL Editor contains an extensive set of functions with

multiple launch points, including menus, toolbars, shortcut

keys, and right mouse menus. You can edit, execute, and

debug statements and scripts from the Edit, Debug, and SQL

Editor menus and toolbars.

In addition to Toad’s Standard toolbar, there are several

related toolbars: the SQL Editor Main toolbar, Standard (or

Common) Edit toolbar, Formatting toolbar, Script Debug-

ging toolbar, Source Control toolbar, SQL Recall toolbar,

and Current Schema toolbar. The SQL Editor also has an

extensive right mouse menu.

Toad’s SQL Editor functions can be executed from several

different locations to accommodate different user orienta-

tions (some users prefer the mouse, others the keyboard;

some like toolbars, ...