List of Oracle SQL Developer Shortcuts
Learn Oracle SQL Developer Shortcuts for Windows
Download Oracle SQL Developer Shortcuts PDF
Most used Oracle SQL Developer Shortcuts
Action |
Oracle SQL Developer Shortcut keys |
Open |
Ctrl + O |
Print |
Ctrl + P |
Save |
Ctrl + S |
Close |
Ctrl + F4 |
Close All |
Ctrl + Shift + F4 |
Copy |
Ctrl + C |
Paste |
Ctrl + V |
Cut |
Ctrl + X |
Copy Path |
Ctrl + Shift + C |
Paste Path |
Ctrl + Shift + V |
Cut Path |
Ctrl + Shift + X |
Undo |
Ctrl + Z |
Redo |
Ctrl + Y |
Select All |
Ctrl + A |
Add Cursor Above |
Alt + Shift + Page Up key |
Add Cursor Below |
Alt + Shift + Page Down key |
Code Editor Shortcuts
Action |
Oracle SQL Developer shortcut keys |
Completion Insight |
Ctrl + Spacebar |
Duplicate the Line |
Ctrl + Shift + D |
Delete Line |
Alt + Shift + D |
Cancel |
Esc |
Delete the Previous character |
Backspace |
Delete Next character |
Shift + Backspace |
Delete to start of the Next word |
Ctrl + Delete |
Delete to start of the Previous word |
Ctrl + Backspace |
Delete to end of line |
Ctrl + Shift + Y |
Jump to the beginning of the line |
Home |
Jump to end of line |
End |
Join Line |
Ctrl + J |
Move line or selection up |
Ctrl + Shift + Up Arrow key |
Move line or selection down |
Ctrl + Shift + Down Arrow key |
Jump to the Next word |
Ctrl + Right Arrow key |
Jump to the Previous word |
Ctrl + Left Arrow key |
Scroll line down |
Ctrl + Down Arrow key |
Scroll line up |
Ctrl + Up Arrow key |
Expand selection left |
Shift + Left Arrow key |
Expand selection right |
Shift + Right Arrow key |
Expand selection up |
Shift + Up Arrow key |
Expand selection down |
Shift + Down Arrow key |
Expand selection to the beginning of the line |
Shift + Home |
Expand selection to end of line |
Shift + End |
Expand selection to closing matching brace |
Alt + Shift + ] |
Expand selection to opening matching brace |
Alt + Shift + [ |
Expand selection to the Next word |
Ctrl + Shift + Right Arrow key |
Expand selection to the Previous word |
Ctrl + Shift + Left Arrow key |
Set the Local tab to size 2 |
Ctrl + 2 |
Set the Local tab to size 4 |
Ctrl + 4 |
Set the Local tab to size 8 |
Ctrl + 8 |
Toggle Line Comment |
Ctrl + / |
Data Editor Shortcuts
Action |
Oracle SQL Developer shortcuts |
Left |
Left Arrow key |
Right |
Right Arrow key |
Up |
Up Arrow key |
Down |
Down Arrow key |
Cell Popup |
Alt + Enter |
Commit Changes |
F11 |
Delete selected rows |
Ctrl + D |
Filter data |
Ctrl + Alt + F |
Insert row |
Ctrl + I |
Refresh |
Ctrl + R |
Rollback changes |
F12 |
Sort |
Ctrl + Alt + S |
Debug Shortcuts
Action |
Oracle SQL Developer shortcuts |
Continue Step |
Shift + F8 |
Find Execution Point |
Alt + F3 |
Inspect |
Ctrl + I |
Resume |
F9 |
Run to Cursor |
F4 |
Step Into |
F7 |
Step Out |
Shift + F7 |
Step Over |
F8 |
Terminate |
Ctrl + F2 |
Toggle Breakpoint |
F5 |
Watch |
Ctrl + F5 |
Metrics Shortcuts
Action |
Oracle SQL Developer shortcuts |
Actual Size |
Shift + Home |
Save Image |
Ctrl + S |
Pan (drag) up |
Up Arrow key |
Pan (drag) down |
Down Arrow key |
Pan (drag) left |
Left Arrow key |
Pan (drag) right |
Right Arrow key |
Zoom in |
Ctrl + Right Arrow key |
Zoom out |
Ctrl + Left Arrow key |
Zoom to Fit |
Ctrl + Home |
Navigate Shortcuts
Action |
Oracle SQL Developer shortcuts |
Backward |
Alt + Left Arrow key |
Forward |
Alt + Right Arrow key |
Toggle Bookmark 0…9 |
Ctrl + Shift + 0…9 |
Go to Bookmark 0…9 |
Ctrl + 0…9 |
Go to the last Edit |
Ctrl + Shift + Backspace |
Goto Line |
Ctrl + G |
Go to Next Bookmark |
Ctrl + Q |
Go to Previous Bookmark |
Ctrl + Shift + Q |
Go to Next Member |
Alt + Down Arrow key |
Go to Previous Member |
Alt + Up Arrow key |
Go to Next Message |
Alt + F8 |
Go to Previous Message |
Alt + F7 |
Go to Recent Files |
Ctrl + = |
Maximize Toggle |
Ctrl + Alt + M |
Navigate down |
Ctrl + ‘ |
Navigate up |
Ctrl + Shift + ‘ |
Source Shortcuts
Action |
Oracle SQL Developer shortcuts |
Code Assist |
Ctrl + Alt + Enter |
Collapse All |
Ctrl + Shift + [ |
Expand All |
Ctrl + Shift + ] |
Collapse Block |
Ctrl + [ |
Expand Block |
Ctrl + ] |
Complete Statement |
Ctrl + Shift + Enter |
Expand Selection |
Ctrl + Shift + = |
Narrow Selection |
Ctrl + Shift + – |
Focus Breadcrumbs |
Ctrl + Shift + . |
Quick Doc |
Ctrl + D |
Reformat |
Alt + Shift + F |
Show Whitespace |
Ctrl + Shift + W |
Worksheet Shortcuts
Action |
Oracle SQL Developer shortcuts |
Autotrace |
F6 |
Clear |
Ctrl + D |
Commit |
F11 |
Explain Plan |
F10 |
Rollback |
F12 |
Run Script |
F5 |
Run Statement |
Ctrl + Enter |
SQL History |
F8 |
SQL Tuning Advisor |
Ctrl + F12 |
SQL Worksheet |
Alt + F10 |
Times Ten Index Advisor |
Ctrl + Shift + X |
Unshared SQL Worksheet |
Ctrl + Shift + N |
Toggle Case |
Ctrl + ‘ |
Window Shortcuts
Action |
Oracle SQL Developer shortcuts |
Activate Document 1…9 |
Alt + 1…9 |
Assign to Alt + 1…9 |
Alt + Shift + 1…9 |
File List |
Alt + 0 |
Left Editor |
Alt + Page Up key |
Right Editor |
Alt + Page Down key |
Next Pane |
F6 |
Previous Pane |
Shift + F6 |
Next File |
Ctrl + Tab |
Previous File |
Ctrl + Shift + Tab |
Left Tab |
Shift + F5 |
Right Tab |
Alt + Shift + F5 |
Show Editor Menu |
Alt + – |
View Shortcuts
Action |
Oracle SQL Developer shortcuts |
Breakpoints |
Ctrl + Shift + R |
Components |
Ctrl + Shift + P |
Freeze Content |
Ctrl + I |
Log |
Ctrl + Shift + L |
Refresh |
Ctrl + R |
Search Shortcuts
Action |
Oracle SQL Developer shortcuts |
Find |
Ctrl + F |
Find Next |
F3 |
Find Previous |
Shift + F3 |
Find Next Word at Cursor |
Ctrl + F3 |
Find Previous Word at Cursor |
Ctrl + Shift + F3 |
Incremental Find Forward |
Ctrl + E |
Incremental Find Backward |
Ctrl + Shift + E |
Global Search |
` |
Replace |
Ctrl + R |
Other Shortcuts
Action |
Oracle SQL Developer shortcuts |
Embed or Expose |
Ctrl + Shift + F7 |
Format |
Ctrl + F7 |
Popup Descrip |
Shift + F4 |
Context Menu |
Shift + F10 |
Properties |
Ctrl + Shift + I |
Quick Action |
Ctrl + Alt + A |
SQL History – append from Next |
Ctrl + Shift + Down Arrow key |
SQL History – append from Previous |
Ctrl + Shift + Up Arrow key |
SQL History – replace with Next |
Ctrl + Down Arrow key |
SQL History – replace with Previous |
Ctrl + Up Arrow key |
Run File |
Ctrl + F11 |
Build or Make |
Ctrl + Shift + F9 |
Build or Rebuild |
Alt + Shift + F9 |
Context Help |
F1 |
Help Backward |
Ctrl + Alt + Left Arrow key |
Help Forward |
Ctrl + Alt + Right Arrow key |
Compile |
Ctrl + F8 |
Compile for Debug |
Ctrl + Shift + F8 |
Debug |
Ctrl + Shift + F10 |
Run |
Ctrl + F10 |
Open Connections |
Alt + V + C |
Select connection and an open a new worksheet |
Alt + F10 |
READ NEXT: