Hotkeys and shortcuts for Oracle SQL Developer 4 (Windows)

(Total 139)

Arrow Keys
Code Editor
Right/ left/ up/ down
Esc
Code Editor
Cancel
Ctrl + Space
Code Editor
Completion Insight
Ctrl + Shift + D
Code Editor
Duplicate the Line
Alt + Shift + D
Code Editor
Delete Line
Backspace / Shift + Backspace
Code Editor
Delete Previous / Next character
Ctrl + Delete
Code Editor
Delete to start of Next word
Ctrl + Backspace
Code Editor
Delete to start of Previous word
Ctrl + Shift + Y
Code Editor
Delete to end of line
Home / End
Code Editor
Jump to beginning of line/ end of line
Ctrl + J
Code Editor
Join Line
Ctrl + Shift + Arrow Up / Arrow Down
Code Editor
Move line or selection up/ down
Ctrl + Arrow Right / Arrow Left
Code Editor
Jump to Next/ Previous word
Ctrl + Arrow Down / Arrow Up
Code Editor
Scroll line down/ up
Shift + Arrow Keys
Code Editor
Expand selection left/ right/ up/ down
Shift + Home / End
Code Editor
Expand selection to beginning/ end of line
Ctrl + Shift + Home / End
Code Editor
Expand selection to beginning/ end of file
Alt + Shift +Close Brackets
Code Editor
Expand selection to closing matching brace
Alt + Shift +Open Brackets
Code Editor
Expand selection to opening matching brace
Ctrl + Shift + Right Arrow / Left Arrow
Code Editor
Expand selection to Next/ Previous word
Ctrl + 2 / 4 / 8
Code Editor
Set Local tab to size 2/ 4/ 8
Ctrl + /
Code Editor
Toggle Line Comment
Arrow Keys
Data Editor
Left/ right/ up/ down
Alt + Enter
Data Editor
Cell Popup
F11
Data Editor
Commit Changes
Ctrl + D
Data Editor
Delete selected row(s)
Ctrl + Alt + F
Data Editor
Filter data
Ctrl + I
Data Editor
Insert row
Ctrl + R
Data Editor
Refresh
F12
Data Editor
Rollback changes
Ctrl + Alt + S
Data Editor
Sort
Ctrl + D
DBMS Output
Clear/ Delete
Ctrl + N
DBMS Output
New
Ctrl + P
DBMS Output
Print
Ctrl + S
DBMS Output
Save
Shift + F8
Debug
Continue Step
Alt + F3
Debug
Find Execution Point
Ctrl + I
Debug
Inspect
F9
Debug
Resume
F4
Debug
Run to Cursor
F7 / Shift + F7
Debug
Step Into/ Step Out
F8
Debug
Step Over
Ctrl + F2
Debug
Terminate
F5
Debug
Toggle Breakpoint
Ctrl + F5
Debug
Watch
Alt + Shift + Page Up / Page Down
Edit
Add Cursor Above/ Below
Ctrl + X / Ctrl + C / Ctrl + V
Edit
Cut/ Copy/ Paste
Ctrl + Shift + X / Ctrl + Shift + C / Ctrl + Shift + V
Edit
Cut/ Copy/ Paste Path
Ctrl + Z / Ctrl + Y
Edit
Undo/ Redo
Ctrl + A
Edit
Select All
Ctrl + O
File
Open
Ctrl + P
File
Print
Ctrl + Shift + F4
File
Save
Ctrl + F4
File
Close
Ctrl + Shift + F4
File
Close All
Shift + Home
Metrics
Actual Size
Ctrl + S
Metrics
Save Image
Arrow Keys
Metrics
Pan (drag) up/down/left/ right
Ctrl + Arrow Right / Ctrl +Drag Right
Metrics
Zoom in
Ctrl + Arrow Left / Ctrl +Drag Left
Metrics
Zoom out
Ctrl + Home
Metrics
Zoom to Fit
Alt + Arrow Left / Arrow Right
Navigate
Backwards/ Forwards
Open Bookmarks
Navigate
Bookmarks
Ctrl + Shift + 09
Navigate
Toggle Bookmark 0…9
Ctrl + 09
Navigate
Go to Bookmark 0…9
Ctrl + Shift + Backspace
Navigate
Go to last Edit
Ctrl + G
Navigate
Goto Line
Ctrl + Q / Ctrl + Shift + Q
Navigate
Go to Next/ Previous Bookmark
Alt + Arrow Down / Arrow Up
Navigate
Go to Next/ Previous Member
Alt + F8 / F7
Navigate
Go to Next/ Previous Message
Ctrl + =
Navigate
Go to Recent Files
Ctrl + Alt + M
Navigate
Maximize Toggle
Ctrl + ' / Ctrl + Shift + '
Navigate
Navigate down/ up
Alt + V + C
Connections
Open Connections
Alt + F10
Connections
Select connection and open new worksheet.
Ctrl + F8
PL/SQL Editor
Compile
Ctrl + Shift + F8
PL/SQL Editor
Compile for Debug
Ctrl + Shift + F10
PL/SQL Editor
Debug
Ctrl + F10
PL/SQL Editor
Run
Ctrl + F
Search
Find
F3 / Shift + F3
Search
Find Next/ Previous
Ctrl + F3 / Ctrl + Shift + F3
Search
Find Next/ Prevoius Word at Cursor
Ctrl + E / Ctrl + Shift + E
Search
Incremental Find Forward/ Backwards
` (grave accent)
Search
Global Search
Ctrl + R
Search
Replace
Ctrl + Alt + Enter
Source
Code Assist
Ctrl + Shift + [ / ]
Source
Collapse/ Expand All
Ctrl + [ / ]
Source
Collape/ Expand Block
Ctrl + Shift + Enter
Source
Complete Statement
Ctrl + Shift + = / -
Source
Expand/ Narrow Selection
Ctrl + Shift + .
Source
Focus Breadcrumbs
Ctrl + D
Source
Quick Doc
Alt + Shift + F
Source
Reformat
Ctrl + Shift + W
Source
Show Whitespace
Ctrl + Shift + R
View
Breakpoints
Ctrl + Shift + P
View
Components
Ctrl + I
View
Freeze Content
Ctrl + Shift + L
View
Log
Ctrl + R
View
Refresh
Alt + 19
Window
Activate Document 1…9
Alt + Shift + 19
Window
Assign to Alt+1…9
Alt + 0
Window
File List
Alt + Page Up / Page Down
Window
Left Editor/ Right Editor
F6 / Shift + F6
Window
Next Pane/ Previous Pane
Ctrl + Tab / Ctrl + Shift + Tab
Window
Next File/ Previous File
Shift + F5 / Alt + Shift + F5
Window
Left Tab/ Right Tab
Alt + -
Window
Show Editor Menu
F6
Worksheet
Autotrace
Ctrl + D
Worksheet
Clear
F11
Worksheet
Commit
F10
Worksheet
Explain Plan
F12
Worksheet
Rollback
F5
Worksheet
Run Script
Ctrl +Enter (or F9)
Worksheet
Run Statement
F8
Worksheet
SQL History
Ctrl + F12
Worksheet
SQL Tuning Advisor
Alt + F10
Worksheet
SQL Worksheet
Ctrl + Shift + X
Worksheet
TimesTen Index Advisor
Ctrl + Shift + N
Worksheet
Unshared SQL Worksheet
Ctrl + '
Worksheet
Toggle Case
Ctrl + Shift + F7
Other
Embed/ Expose
Ctrl + F7
Other
Format
Shift + F4
Other
Popup Descrip
Shift + F10
Other
Context Menu
Ctrl + Shift + I
Other
Properties
Ctrl + Alt + A
Other
Quick Action
Ctrl + Shift + Arrow Down / Arrow Up
Other
SQL History - append from Next/ Previous
Ctrl + Arrow Down / Arrow Up
Other
SQL History - replace with Next/ Previous
Ctrl + F11
Other
Run File
Ctrl + Shift + F9
Other
Build/ Make
Alt + Shift + F9
Other
Build/ Rebuild
F1
Other
Context Help
Ctrl + Alt + Arrow Left / Arrow Right
Other
Help Backwards/ forward
cf
Code Snippets
CREATE FUNCTION function_name
cp
Code Snippets
CREATE PROCEDURE procedure_name
ct
Code Snippets
CREATE TABLE table ()
df
Code Snippets
DELETE FROM table WHERE
II
Code Snippets
Insert Into table VALUES ()
ssf
Code Snippets
SELECT * FROM table