Show Menu
Cheatography

Oracle SQL Developer Keyboard Shortcuts by

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 + '
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
           

Help Us Go Positive!

We offset our carbon usage with Ecologi. Click the link below to help us!

We offset our carbon footprint via Ecologi
 

Comments

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
          utPLSQL 3.1.10 Cheat Sheet

          More Cheat Sheets by thatjeffsmith

          SQLDev KB Shortcuts OS X Cheat Sheet