0% found this document useful (0 votes)
6 views

sql_developer_shortcuts

Uploaded by

anjinayulu143
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
6 views

sql_developer_shortcuts

Uploaded by

anjinayulu143
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

SQL​ ​Developer​ ​-​ ​Keyboard​ ​Shortcuts

This​ ​guide​ ​contains​ ​a​ ​list​ ​of​ ​all​ ​of​ ​the​ ​default​ ​keyboard​ ​shortcuts​ ​in​ ​SQL​ ​Developer.​ ​You​ ​can​ ​change​ ​them​ ​by​ ​going​ ​to​ ​Tools​ ​>
Preferences​ ​>​ ​Shortcut​ ​Keys.

Code​ ​Editor Selection​ ​Up: Shift​ ​Up


Move​ ​Page​ ​Up: Page​ ​Up Insert​ ​Tab: Tab
Move​ ​Page​ ​Down: Page​ ​Down Up: Up
Delete​ ​Previous​ ​Char: Backspace
Matching​ ​Brace: Alt​ ​Open​ ​Bracket PL/SQL​ ​Editor
Matching​ ​Brace Alt​ ​Close​ ​Bracket Compile: Ctrl​ ​F8
Delete​ ​to​ ​Previous​ ​Word​ ​Start: Ctrl​ ​Backspace Compile​ ​for​ ​Debug: Ctrl​ ​Shift​ ​F8
Unselect: Ctrl​ ​Backslash Debug: Ctrl​ ​Shift​ ​F10
Set​ ​Local​ ​Tab​ ​Size​ ​to​ ​2: Ctrl​ ​2 Run: Ctrl​ ​F10
Set​ ​Local​ ​Tab​ ​Size​ ​to​ ​4: Ctrl​ ​4
Set​ ​Local​ ​Tab​ ​Size​ ​to​ ​8: Ctrl​ ​8 Debug
Delete​ ​to​ ​Next​ ​Word​ ​Start: Ctrl​ ​Delete Find​ ​Execution​ ​Point: Alt​ ​F3
Scroll​ ​Line​ ​Down: Ctrl​ ​Down Terminate: Ctrl​ ​F2
End​ ​of​ ​File: Ctrl​ ​End Watch: Ctrl​ ​F5
Start​ ​of​ ​File: Ctrl​ ​Home Inspect: Ctrl​ ​I
Join​ ​Line: Ctrl​ ​J Run​ ​to​ ​Cursor: F4
Previous​ ​Word​ ​Start: Ctrl​ ​Left Step​ ​Into: F7
Next​ ​Word​ ​Start: Ctrl​ ​Right Step​ ​Over: F8
Toggle​ ​Line​ ​Comments: Ctrl​ ​Slash Resume: F9
Completion​ ​Insight: Ctrl​ ​Space Toggle​ ​Breakpoint: Ctrl​ ​Shift​ ​F5
Delete​ ​to​ ​Next​ ​Word​ ​Start: Ctrl​ ​T Step​ ​Out: Shift​ ​F7
Scroll​ ​Line​ ​Up: Ctrl​ ​Up Continue​ ​Step: Shift​ ​F8
Down: Down
End​ ​of​ ​Line: End Worksheet
Insert​ ​New​ ​Line: Enter TimesTen​ ​Index​ ​Advisor: Ctrl​ ​Shift​ ​X
Cancel: Escape SQL​ ​Worksheet: Alt​ ​F10
Start​ ​of​ ​Line: Home Clear: Ctrl​ ​D
Toggle​ ​Insert​ ​Mode: Insert Run​ ​Statement: Ctrl​ ​Enter
Backward: Left SQL​ ​Tuning​ ​Advisor: Ctrl​ ​F12
Forward: Right Explain​ ​Plan: F10
Selection​ ​Page​ ​Up: Shift​ ​Page​ ​Up Commit: F11
Selection​ ​Page​ ​Down: Shift​ ​Page​ ​Down Rollback​ ​Changes: F12
Delete​ ​Previous​ ​Char: Shift​ ​Backspace Run​ ​Script: F5
Selection​ ​to​ ​Matching​ ​Brace: Alt​ ​Shift​ ​Open​ ​Bracket Autotrace: F6
Selection​ ​to​ ​Matching​ ​Brace: Alt​ ​Shift​ ​Close​ ​Bracket SQL​ ​History: F8
Delete​ ​Current​ ​Line: Alt​ ​Shift​ ​D Run​ ​Statement: F9
Duplicate​ ​Selection: Ctrl​ ​Shift​ ​D Unshared​ ​SQL​ ​Worksheet: Ctrl​ ​Shift​ ​N
Move​ ​Down: Ctrl​ ​Shift​ ​Down To​ ​Upper/Lower/InitCap: Ctrl​ ​Shift​ ​Quote
Selection​ ​to​ ​End​ ​of​ ​File: Ctrl​ ​Shift​ ​End
Selection​ ​to​ ​Start​ ​of​ ​File: Ctrl​ ​Shift​ ​Home Data​ ​Editor
Selection​ ​to​ ​Previous​ ​Word​ ​Start: Ctrl​ ​Shift​ ​Left Commit​ ​Changes: F11
Selection​ ​to​ ​Next​ ​Word​ ​Start: Ctrl​ ​Shift​ ​Right Delete​ ​Selected​ ​Row(s): Ctrl​ ​D
Toggle​ ​Line​ ​Comments: Ctrl​ ​Shift​ ​Slash Filter​ ​Data: Ctrl​ ​Alt​ ​F
Move​ ​Up: Ctrl​ ​Shift​ ​Up Insert​ ​Row: Ctrl​ ​I
Delete​ ​until​ ​End​ ​of​ ​Line: Ctrl​ ​Shift​ ​Y Refresh: Ctrl​ ​R
Selection​ ​Down: Shift​ ​Down Rollback​ ​Changes: F12
Selection​ ​to​ ​End​ ​of​ ​Line: Shift​ ​End Sort: Ctrl​ ​Alt​ ​S
New​ ​Line: Shift​ ​Enter Commit​ ​Changes: F11
Selection​ ​to​ ​Start​ ​of​ ​Line: Shift​ ​Home
Selection​ ​Backward: Shift​ ​Left Edit
Selection​ ​Forward: Shift​ ​Right Undo: Alt​ ​Backspace
Reverse​ ​Tab: Shift​ ​Tab Select​ ​All: Ctrl​ ​A

www.databasestar.com
Copy: Ctrl​ ​C File​ ​List: Alt​ ​0
Copy: Ctrl​ ​Insert Show​ ​Editor​ ​Menu: Alt​ ​Minus
Paste: Ctrl​ ​V Previous​ ​File: Ctrl​ ​Shift​ ​Tab
Cut: Ctrl​ ​X Left​ ​Tab: Shift​ ​F5
Redo: Ctrl​ ​Y
Undo: Ctrl​ ​Z Search
Delete: Delete Global​ ​Search: Ctrl​ ​Back​ ​Quote
Add​ ​Cursor​ ​Above: Alt​ ​Shift​ ​Page​ ​Up Incremental​ ​Find​ ​Forward: Ctrl​ ​E
Add​ ​Cursor​ ​Below: Alt​ ​Shift​ ​Page​ ​Down Find​ ​Next​ ​Word​ ​at​ ​Cursor: Ctrl​ ​F3
Redo: Alt​ ​Shift​ ​Backspace Find​ ​Previous​ ​Word​ ​at​ ​Cursor: Ctrl​ ​Shift​ ​F3
Copy​ ​Path: Ctrl​ ​Shift​ ​C Find: Ctrl​ ​F
Delete: Ctrl​ ​Shift​ ​D Replace: Ctrl​ ​R
Extended​ ​Paste: Ctrl​ ​Shift​ ​V Find​ ​Next: F3
Redo: Ctrl​ ​Shift​ ​Z Incremental​ ​Find​ ​Backward: Ctrl​ ​Shift​ ​E
Cut: Shift​ ​Delete Find​ ​Previous: Shift​ ​F3
Paste: Shift​ ​Insert
Source
Navigate Collapse​ ​Block: Ctrl​ ​Open​ ​Bracket
Go​ ​To​ ​Next​ ​Member: Alt​ ​Down Expand​ ​Block: Ctrl​ ​Close​ ​Bracket
Go​ ​to​ ​Previous​ ​Message: Alt​ ​F7 Code​ ​Assist: Ctrl​ ​Alt​ ​Enter
Go​ ​to​ ​Next​ ​Message: Alt​ ​F8 Reformat: Ctrl​ ​Alt​ ​L
Back: Alt​ ​Left Focus​ ​Breadcrumbs: Ctrl​ ​Shift​ ​Period
Forward: Alt​ ​Right Quick​ ​Doc: Ctrl​ ​D
Go​ ​to​ ​Previous​ ​Member: Alt​ ​Up Show​ ​Whitespace: Ctrl​ ​Shift​ ​W
Navigate​ ​Hierarchy: Ctrl​ ​Alt​ ​Quote Complete​ ​Statement: Ctrl​ ​Shift​ ​Enter
Bookmarks: Ctrl​ ​Shift​ ​K Expand​ ​Selection: Ctrl​ ​Shift​ ​Equals
Go​ ​To​ ​Bookmark​ ​1-9: Ctrl​ ​1​ ​-​ ​Ctrl​ ​9 Narrow​ ​Selection: Ctrl​ ​Shift​ ​Minus
Go​ ​To​ ​Next​ ​Bookmark: Ctrl​ ​Q Reformat: Alt​ ​Shift​ ​F
Go​ ​To​ ​Previous​ ​Bookmark: Ctrl​ ​Shift​ ​Q Collapse​ ​All: Ctrl​ ​Shift​ ​Open​ ​Bracket
Toggle​ ​Bookmark: Ctrl​ ​K Expand​ ​All: Ctrl​ ​Shift​ ​Close​ ​Bracket
Toggle​ ​Bookmark​ ​0-9: Ctrl​ ​Shift​ ​0​ ​-​ ​Ctrl​ ​Shift​ ​9
Go​ ​To​ ​Line: Ctrl​ ​G Diagram
Navigate​ ​Down: Ctrl​ ​Quote Zoom​ ​100%: Ctrl​ ​0
Go​ ​To​ ​Last​ ​Edit: Ctrl​ ​Shift​ ​Backspace
Navigate​ ​Up: Ctrl​ ​Shift​ ​Quote Run
Go​ ​To​ ​Recent​ ​Files: Ctrl​ ​Equals Run​ ​File: Ctrl​ ​F11
Maximise​ ​Toggle: Ctrl​ ​Alt​ ​M
View
File Freeze​ ​Content: Ctrl​ ​I
Exit: Alt​ ​F4 Refresh: Ctrl​ ​R
Close: Ctrl​ ​F4 Refresh: F5
New: Ctrl​ ​N Log: Ctrl​ ​Shift​ ​L
Open: Ctrl​ ​O Components: Ctrl​ ​Shift​ ​P
Print: Ctrl​ ​P Breakpoints: Ctrl​ ​Shift​ ​R
Save: Ctrl​ ​S Thumbnail: Ctrl​ ​Shift​ ​T
Close: Ctrl​ ​W
Close​ ​All: Ctrl​ ​Shift​ ​F4 DBMS_Output
Clear: Ctrl​ ​D
Window New: Ctrl​ ​N
Left​ ​Editor: Alt​ ​Page​ ​Up Print: Ctrl​ ​P
Right​ ​Editor: Alt​ ​Page​ ​Down Save​ ​File: Ctrl​ ​S
Next​ ​File: Ctrl​ ​F6
Next​ ​File: Ctrl​ ​Tab Build
Right​ ​Tab: Alt​ ​Shift​ ​F5 Rebuild: Alt​ ​Shift​ ​F9
Previous​ ​File: Ctrl​ ​Shift​ ​F6 Make: Ctrl​ ​Shift​ ​F9
Activate​ ​Document​ ​1-9: Alt​ ​1​ ​-​ ​Alt​ ​9
Assign​ ​Document​ ​1-9: Alt​ ​Shift​ ​1​ ​-​ ​Alt​ ​Shift​ ​9 Versioning
Next​ ​Pane: F6 Properties​ ​(Versioning): Ctrl​ ​Shift​ ​O
Previous​ ​Pane: Shift​ ​F6

www.databasestar.com
Cart Show​ ​SQL: Ctrl​ ​Q
Copy: Ctrl​ ​C Toggle​ ​Inputs: Ctrl​ ​L
Deploy​ ​Cloud: Ctrl​ ​D Actual​ ​Size: Shift​ ​Home
Diff​ ​Carts:: Ctrl​ ​I Zoom​ ​In: Ctrl​ ​Right
Export​ ​Cart:: Ctrl​ ​E Zoom​ ​Out: Ctrl​ ​Left
Select​ ​Cart​ ​To​ ​Left: Shift​ ​F5 Zoom​ ​to​ ​Fit: Ctrl​ ​Home
Select​ ​Cart​ ​To​ ​Right: Ctrl​ ​Shift​ ​F5 Save​ ​to​ ​File: Ctrl​ ​S
New​ ​Cart: Ctrl​ ​N
Open​ ​Cart: Ctrl​ ​O Other
Refresh​ ​Cart: Ctrl​ ​R Format: Ctrl​ ​F7
Save​ ​Cart: Ctrl​ ​S Advanced​ ​Format: Ctrl​ ​Shift​ ​F7
Save​ ​All​ ​Carts: Alt​ ​L Popup​ ​Describe: Shift​ ​F4
Save​ ​As​ ​Cart: Alt​ ​A Popup​ ​Menu: Context​ ​Menu
Add​ ​Final​ ​Script: Ctrl​ ​Shift​ ​F Delete​ ​geometry​ ​layer: Ctrl​ ​D
Add​ ​Initial​ ​Script: Ctrl​ ​Shift​ ​N SQL​ ​History:​ ​Replace​ ​with​ ​Next: Ctrl​ ​Down
Delete​ ​Row: Ctrl​ ​Shift​ ​D Zoom​ ​fit: Ctrl​ ​F
Select​ ​All​ ​Cart: Ctrl​ ​A Zoom​ ​in: Ctrl​ ​I
Marquee​ ​Zoom: Ctrl​ ​M
DBA Add​ ​geometry​ ​layer: Ctrl​ ​N
Generate​ ​Report: Ctrl​ ​G Zoom​ ​out: Ctrl​ ​O
Open​ ​in​ ​Browser: Ctrl​ ​O Refresh​ ​map​ ​view: Ctrl​ ​R
Pan​ ​Down: Down New​ ​map​ ​view​ ​tab: Ctrl​ ​T
Pan​ ​Left: Left SQL​ ​History​ ​Replace​ ​with​ ​Previous: Ctrl​ ​Up
Pan​ ​Right: Right SQL​ ​History​ ​Append​ ​from​ ​Next: Ctrl​ ​Shift​ ​Down
Pan​ ​Up: Up SQL​ ​History​ ​Append​ ​from​ ​Previous: Ctrl​ ​Shift​ ​Up
Save​ ​to​ ​File: Ctrl​ ​S Properties: Ctrl​ ​Shift​ ​I
Popup​ ​Menu: Shift​ ​F10

www.databasestar.com

You might also like