TOAD SQL Editor

Predefined Shortcuts

Keyboard shortcuts are one of the features that make TOAD so powerful and easy to use. TOAD comes with a host of predefined shortcuts. These shortcuts save keystrokes and mouse actions and perform a variety of tasks such as issuing a describe on the current highlighted object, or find (find next, find previous, and so on). The shortcuts differ slightly between the SQL Editor and the PL/SQL Editor (covered in Chapter 4). This section focuses on the shortcuts for the SQL Editor only.

Table 3.1 shows all the shortcuts in keystroke order and Table 3.2 shows all the shortcuts in description order. The third column refers you to the figure in this chapter where the shortcut is illustrated.

Table 3.1 SQL Editor Shortcuts by Keystroke

Shortcut

Description

Illustration

F1

Windows Help File

F2

Toggle Output Window

Figure 3.2

Shift+F2

Toggle Data Grid Window

F3

Find Next Occurrence

Shift+F3

Find Previous Occurrence

F4

Describe Table, View, Procedure, Function

Figure 3.26

F5

Execute SQL as a script

Figure 3.34

F6

Toggle between SQL Editor and Results Panel

Figure 3.1

F7

Clear All Text

F8

Recall Previous SQL Statement

F9

Execute Statement

Figure 3.33

Ctrl+F9

Set Code Execution Parameters

Figure 3.33

Shift+F9

Execute Current SQL statement at Cursor

F10 or right-click

Pop-up Menu

Figures 3.4, 3.10

Ctrl+F12

External Editor, Pass Contents

Figures 3.5, 3.6

Ctrl+A

Select All Text

Ctrl+C

Copy

Ctrl+E

Execute Explain Plan on the Current Statement

Figure 3.41

Ctrl+F

Find Text

Ctrl+G

Goto Line

Ctrl+L

Convert Text to Lowercase

Ctrl+M

Make Code Statement

Ctrl+N

Recall Named SQL Statement

Ctrl+O

Open a Text File

Ctrl+P

Strip Code Statement

Ctrl+R

Find and Replace

Ctrl+S

Save File

Shift+Ctrl+S

Save File As

Figure 3.18

Ctrl+T

Columns Drop-down

Shift+Ctrl+R

Alias Replacement

Shift+Ctrl+T

Columns Drop-Down no alias

Figure 3.19

Ctrl+Spacebar

Code Templates

Figure 3.30

Ctrl+U

Converts Text to Uppercase

Ctrl+V

Paste

Ctrl+X

Cut

Ctrl+Z

Undo Last Change

Ctrl+.

Display Pop-up List of Matching Table Names

Figure 3.16

Shift+Ctrl+Z

Redo Last Undo

Alt+Up Arrow

Display Previous Statement

Figure 3.7

Alt+Down Arrow

Display Next Statement (After Alt+Up Arrow)

Figure 3.7

Ctrl+Home

In the data grid: goes to the top of the record set

Ctrl+End

In the data grid: goes to the end of the record set

Ctrl+Tab

Cycles through the Collection of MDI Child Windows

TIP

The competent TOAD user makes use of Shift+F9 to execute SQL statements one at a time out of a script, and F8 to recall the previous SQL statement. The TOAD user also makes use of cut and paste to move code between TOAD windows.

Shift+F9 executes single SQL statements.

F8 recalls the previous SQL statement.

Table 3.2 SQL Editor Shortcuts by Description

Description

Shortcut

Illustration

Alias Replacement

Shift+Ctrl+R

Clear All Text

F7

Code Templates

Ctrl+Spacebar

Figure 3.30

Columns Drop-down

Ctrl+T

Figure 3.18

Columns Drop-down no alias

Shift+Ctrl+T

Figure 3.19

Convert Text to Lowercase

Ctrl+L

Convert Text to Uppercase

Ctrl+U

Copy

Ctrl+C

Cut

Ctrl+X

Cycles through the Collection of MDI Child Windows

Ctrl+Tab

Describe Table, View, Procedure, Function, or Package

F4

Display Next Statement (After Alt+Up Arrow)

Alt+Down Arrow

Figure 3.7

Display Previous Statement

Alt+Up Arrow

Figure 3.7

Display Pop-up List of Matching Table Names

Ctrl+.

Figure 3.16

Execute Current SQL Statement at Cursor

Shift+F9

Execute SQL as a Script

F5

Figure 3.35

Execute Explain Plan on the Current SQL Statement

Ctrl+E

Figure 3.41

Execute SQL Statement

F9

Figure 3.34

External Editor, Pass Contents

Ctrl+F12

Figure 3.5

Find and Replace

Ctrl+R

Find Next Occurrence

F3

Find Previous Occurrence

Shift+F3

Find Text

Ctrl+F

Goto Line

Ctrl+G

In the data grid: goes to the end of the record set

Ctrl+End

In the data grid: goes to the top of the record set

Ctrl+Home

Make Code Statement

Ctrl+M

Open a Text File

Ctrl+O

Paste

Ctrl+V

Pop-up Menu

F10 or RT-Mouse

Figures 3.4, 3.10

Recall Named SQL

Ctrl+N

Recall Previous SQL Statement

F8

Redo Last Undo

Shift+Ctrl+Z

Save File

Ctrl+S

Save File As

Shift+Ctrl+S

Select All Text

Ctrl+A

Strip Code Statement

Ctrl+P

Toggle between SQL Editor and Results Panel

F6

Figure 3.1

Toggle Full Screen Editor

F2

Figure 3.2

Undo Last Change

Ctrl+Z

Verify Statement Without Execution (Parse)

Ctrl+F9

Windows Help File