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	F1

Reference : http://www.informit.com/articles/article.aspx?p=31544&seqNum=2