0% found this document useful (0 votes)
59 views3 pages

SQL Developer Keyboard Shortcuts Guide

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)
59 views3 pages

SQL Developer Keyboard Shortcuts Guide

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

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

[Link]
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

[Link]
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

[Link]

You might also like