Cheatography
https://cheatography.com
Let your fingers do the talking
SQL Worksheet
Execute Query |
Ctrl+Enter or F9 |
Execute Script |
F5 |
Explain Plan |
F10 |
Autotrace |
F6 |
SQL Recall |
Ctrl + Up/Down |
SQL Recall Append |
Ctrl + Shift + Up/Down |
SQL History |
F8 |
Completion Insight |
Ctrl + Spacebar |
Format |
Ctrl + F7 |
Search Database |
Alt+G |
Toggle Comment |
Ctrl + / |
Toggle Case |
Ctrl + Shift + ' |
Incremental Search |
Ctrl + e |
Switch to Results |
Alt + PgDn |
Switch to Editor |
Alt + PgUp |
Open Unshared Worksheet |
Ctrl + Shift + N |
DESC |
Shift + F4 |
|
|
SQLcl
Run buffer immediately |
Ctrl + R |
Go to top of buffer |
Ctrl + W |
Go to bottom of buffer |
Ctrl + S |
Go to start of line |
Ctrl + A |
Go to end of line |
Ctrl + E |
Recall Previous |
Up or Down |
File/SQL Completion |
Tab |
Clear Screen |
Ctrl + L |
Data Grids
Find Data |
Ctrl + F |
Copy with Column Headers |
Ctrl + Shift + C |
Commit |
F11 |
Rollback |
F12 |
Notes
These are the defaults for Windows OS. They can be changed, exported, and imported via the preferences. |
|
|
Debugger
Step Over |
F8 |
Step Into |
F7 |
Step Out |
Shift + F7 |
Run to Cursor |
F4 |
Find Execution Point |
Alt + F3 |
Resume |
F9 |
Toggle Breakpoint |
Ctrl + Shift + F5 |
Potpourri
Next Document/Window |
Ctrl + F6 |
Previous Doc/Window |
Ctrl + Shift + F6 |
View Log |
Ctrl + Shift + L |
Refresh |
F5 |
|
Created By
www.thatjeffsmith.com
Metadata
Favourited By
Comments
built using SQL Developer 4.1.2 on Windows 7
Add a Comment
Related Cheat Sheets
More Cheat Sheets by thatjeffsmith