Toad Tips

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