TOAD SQL Editor – Predefined Shortcuts

Shortcut Description  
F1 Windows Help File  
F2 Toggle Output Window  
Shift+F2 Toggle Data Grid Window  
F3 Find Next Occurrence  
Shift+F3 Find Previous Occurrence  
F4 Describe Table, View, Procedure, Function  
F5 Execute SQL as a script  
F6 Toggle between SQL Editor and Results Panel  
F7 Clear All Text  
F8 Recall Previous SQL Statement  
F9 Execute Statement  
Ctrl+F9 Set Code Execution Parameters  
Shift+F9 Execute Current SQL statement at Cursor  
F10 or right-click Pop-up Menu  
Ctrl+F12 External Editor, Pass Contents  
Ctrl+A Select All Text  
Ctrl+C Copy  
Ctrl+E Execute Explain Plan on the Current Statement  
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  
Ctrl+T Columns Drop-down  
Shift+Ctrl+R Alias Replacement  
Shift+Ctrl+T Columns Drop-Down no alias  
Ctrl+Spacebar Code Templates  
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  
Shift+Ctrl+Z Redo Last Undo  
Alt+Up Arrow Display Previous Statement  
Alt+Down Arrow Display Next Statement (After Alt+Up Arrow)  
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  
Description Shortcut  
Alias Replacement Shift+Ctrl+R  
Clear All Text F7  
Code Templates Ctrl+Spacebar  
Columns Drop-down Ctrl+T  
Columns Drop-down no alias Shift+Ctrl+T  
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  
Display Previous Statement Alt+Up Arrow  
Display Pop-up List of Matching Table Names Ctrl+.  
Execute Current SQL Statement at Cursor Shift+F9  
Execute SQL as a Script F5  
Execute Explain Plan on the Current SQL Statement Ctrl+E  
Execute SQL Statement F9  
External Editor, Pass Contents Ctrl+F12  
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  
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  
Toggle Full Screen Editor F2  
Undo Last Change Ctrl+Z  
Verify Statement Without Execution (Parse) Ctrl+F9  
Windows Help File F1  
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: