Show Menu
Cheatography
  1. Home >
  2. Programming >

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
 

Metadata

  • Languages:
  • Published: 9th November, 2015
  • Last Updated: 12th May, 2016
  • Rated: 5 stars based on 1 ratings

Favourited By

ally_m_uk petedk jgebal crocusrick

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