Show Menu

Oracle SQL Developer Keyboard Shortcuts by

Let your fingers do the talking
sql     ide     oracle     plsql

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 + '
Increm­ental 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 immedi­ately
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 prefer­ences.
 

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 Docume­nt/­Window
Ctrl + F6
Previous Doc/Window
Ctrl + Shift + F6
View Log
Ctrl + Shift + L
Refresh
F5

Download the Oracle SQL Developer Keyboard Shortcuts

1 Page
//media.cheatography.com/storage/thumb/thatjeffsmith_oracle-sql-developer.750.jpg

PDF (recommended)

Alternative Downloads

Share This Cheat Sheet!

 

Comments

thatjeffsmith thatjeffsmith, 20:26 9 Nov 15

built using SQL Developer 4.1.2 on Windows 7

Add a Comment

Your Comment

Please enter your name.

    Please enter your email address

      Please enter your Comment.

          Related Cheat Sheets

          SQLDev KB Shortcuts OS X Cheat Sheet
          SQL retrieval functions 1 Cheat Sheet

          More Cheat Sheets by thatjeffsmith

          SQLDev KB Shortcuts OS X Cheat Sheet