Oracle SQL Developer Shortcut Key Combinations
SQL Developer Accelerator Hotkeys
The following accelerator hotkeys are the default for Oracle SQL Developer v1.2:
SQL Developer
Context Help F1 or Shift-F1
Exit Alt-F4
Files
New Ctrl-N
Open Ctrl-O
Close Ctrl-F4 or Ctrl-W
Close All Ctrl-Shift-F4
Save Ctrl-S
Print Ctrl-P
Editors
Undo Ctrl-Z or Alt-Shift-Backspace
Redo Ctrl-Y or Alt-Backspace
Cut Ctrl-X or Shift-Delete
Copy Ctrl-C or Ctrl-Insert
Copy Path Ctrl-Shift-C
Paste Ctrl-V or Shift-Insert
Extended Paste Ctrl-Shift-V
Delete Delete
Delete to Next Word Start Ctrl-Delete or Ctrl-T
Delete to Previous Word Start Ctrl Backspace
Delete Until to End of Line Ctrl-Shift-Y
Move to Next Word Start Ctrl-Right
Move to Previous Word Start Ctrl-Left
Move to Matching Bracket Alt-[ or Alt-]
Select All Ctrl-A
Selection to Matching Brace Alt-Shift-[ or Alt-Shift-]
Completion Insight Ctrl-Space
Smart Completion Insight Ctrl-Alt-Space
Toggle line comments Ctrl-Shift-/ or Ctrl-/
Format SQL Ctrl-B
Search
Find Ctrl-F
Find Next F3
Find Next Word at Cursor Ctrl-F3
Find Previous Shift-F3
Find Previous Word at Cursor Ctrl-Shift-F3
Replace Ctrl-R
Incremental Find Forward Ctrl-E
Incremental Find Backward Ctrl-Shift-E
Navigation
Back Alt-Left
Forward Alt-Right
Toggle Bookmark Ctrl-K
Go to Bookmarks Ctrl-Shift-K
Go to Next Bookmarks Ctrl-Q
Go to Previous Bookmarks Ctrl-Shift-Q
Go to Line Ctrl-G
Go to Last Edit Ctrl-Shift-Backspace
Browse Symbol Ctrl-Minus
Go to Recent Files Ctrl-Equals
Go to Next Message Alt-F8
Go to Last Message Alt-F7
Assign and activate window Alt-Shift-1...9 and Alt-1...9
Windows
Popup menu Shift-F10
System menu Alt-minus
File List Alt-0
SQL Worksheet
Execute Statement F9
Run Script F15
Commit F11
Rollback F12
Cancel Ctrl-Q
SQL History F8
Execute Explain Plan F6
Autotrace F10
Clear Ctrl-D
PL/SQL Editor
Toggle Breakpoint F5
Compile Ctrl-Shift-F9 - Ctrl-Shift-M
Log
Log Window Ctrl-Shift-L
Go to Next Message Alt-F8
Go to Last Message Alt-F7
Debugging
Debug Project Shift-F9
Breakpoint Window Ctrl-Shift-R
Toggle Breakpoint F5
Resume F9
Step Over F8
Step Into F7
Step Out Shift-F7
Continue Step Shift-F8
Run to Cursor F4
Terminate Ctrl-F2
Watch Ctrl-F5
All keys can be reassigned via the Tools menu
Preferences Accelerator options.
The names for the hotkeys above are taken from the Accelerator options. They have
not been renamed for clarity, such that they can be easily located in the Accelerator
options.
The following hotkeys appear to be broken but may be fixed in a later release:
Convert Leading Spaces to Tabs Ctrl-Shift-T
Convert Leading Tabs to Spaces Ctrl-Shift-U
Set Local Tab Size to 2 Ctrl-2
Set Local Tab Size to 4 Ctrl-4
Set Local Tab Size to 8 Ctrl-8
Browse Symbol Ctrl Minus
Parameter Insight Ctrl-Shift-Space