Home > Articles > Data > Oracle

TOAD SQL Editor

  • Print
  • + Share This
  • 💬 Discuss

This chapter is from the book

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

F1

 


  • + Share This
  • 🔖 Save To Your Account
TOAD Handbook

This chapter is from the book

TOAD Handbook

Discussions

comments powered by Disqus