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!

Like this cheat sheet? Check out our sponsors!

Readable.io is a collection of tools to make your writing better. More readable content means higher conversion rates and better reader engagement. Measure website and document readability, measure keyword density and more!

Click Here To Get Started!

 

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

          Sublime Text 2 Windows Keyboard Shortcuts
          SQLDev KB Shortcuts OS X Cheat Sheet

          More Cheat Sheets by thatjeffsmith

          SQLDev KB Shortcuts OS X Cheat Sheet