Toad provides dozens of standard shortcut keys, plus you can assign new ones or customize the standard ones. Toad also allows you to print out your current list of shortcut keys.
| General | Description |
|
CTRL+D |
Open Quick Describe window. |
|
CTRL+TAB |
Cycle through a collection of “child windows” or tabs in a window |
|
F1 |
Open the Toad documentation |
|
F4 |
Immediately describe object in popup window. |
|
F10 |
Display right-click menu |
| Debugger | Description |
|
CTRL+F5 |
Add watch at cursor |
|
CTRL+ALT+B |
Display the PL/SQL Debugger Breakpoints window |
|
CTRL+ALT+D |
Display the PL/SQL Debugger DBMS Output window |
|
CTRL+ALT+E |
Display the PL/SQL Debugger Evaluate/Modify window |
|
CTRL+ALT+C |
Display the PL/SQL Debugger Call Stack window |
|
CTRL+ALT+W |
Display the PL/SQL Debugger Watches window |
|
F11 |
Run (continue execution) |
|
F12 |
Run to cursor |
|
SHIFT+F5 |
Set or delete a breakpoint on the current line |
|
SHIFT+F7 |
Trace into |
|
SHIFT+F8 |
Step over |
|
SHIFT+F10 |
Trace out |
|
SHIFT+CTRL+F9 |
Set parameters |
| Editor | Description |
|
ALT+UP |
Display previous statement |
|
ALT+DOWN |
Display next statement (after ALT+UP) |
|
CTRL+B |
Comment block |
|
CTRL+E |
Execute Explain Plan on the current statement |
|
CTRL+M |
Make code statement. |
|
CTRL+N |
Find sum of the selected fields. You can also include additional calculations, such as the average or count. |
|
CTRL+P |
Strip code statement. |
|
CTRL+T |
Display pick list drop-down
There are a variety of shortcut keys to use with the pick list. |
|
CTRL+F9 |
Verify statement without execution (parse) in the Editor |
|
CTRL+F12 |
Pass the SQL or Editor contents to the specified external editor. |
|
CTRL+PERIOD |
Display code completion list |
|
CTRL+ENTER |
Execute current SQL (same as SHIFT+F9) |
|
CTRL+ALT+PAGEUP |
Navigate to the previous results panel tab |
|
CTRL+ALT+PAGEDOWN |
Navigate to the next results panel tab |
|
F2 |
Toggle full screen Editor |
|
F5 |
Execute as script. |
|
F6 |
Toggle between Editor and Results panel |
|
F7 |
Clear all text, trace into the Editor |
|
F8 |
Recall previous SQL statement in the Editor |
|
F9 |
Execute statement in the Editor |
|
SHIFT+F2 |
Toggle full screen grid |
| Find and Replace | Description |
|
CTRL+F |
Find text |
|
CTRL+G |
Go to line number |
|
CTRL+R |
Find and replace |
|
F3 |
Find next occurrence |
|
SHIFT+F3 |
Find previous occurrence |
See “Code Assist Options” in the online help for more information.
There are a variety of shortcuts you can use to display the pick list and make a selection. Toad also provides options for you to customize the pick list behavior.Toad Insight Pick List Shortcuts
| General | Description |
|
CTRL+T |
Display pick list for object (name) at caret. If a stored alias exists by that name, then that alias’ object is shown in the pick list. |
|
CTRL+SHIFT+T |
Display pick list for object (name) at caret. This option ignores aliases with the same name. |
|
LEFT ARROW |
Move the caret left while filtering the pick list. |
|
RIGHT ARROW |
Move the caret right while filtering the pick list. |
| Make Selection | Description |
|
Double-click the selection |
Insert the selection and close the pick list. |
|
ENTER |
Insert the selection and close the pick list. |
|
PERIOD |
Insert the selection and a period after it. The pick list remains open and displays child objects, if there are any. |
|
SPACE |
Insert the selection and a space after it. |
|
TAB |
Insert the a partial selection if possible and leave the pick list open; if a partial selection is not possible, insert the selection and close the pick list.
TAB accepts as much as possible without changing the list of displayed objects. For example, if the pick list displays a list of columns that all start with MY_COL, Toad would insert MY_COL when you press TAB and leave the picklist open. If the columns did not have a common preface, Toad would insert the selected column and close the pick list. |
|
( OPEN PARENTHESIS |
Insert the selection and “(” after it. |
| Close Pick List | Description |
|
Click outside the pick list |
Close the pick list without making a selection. |
|
ESC |
Close the pick list without making a selection. |
