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.
| 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 |
 | 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. |
 |
| 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 |