139 Shortcuts for Oracle SQL Developer 4 (Windows)  [edit]

minimize Hide all  maximize Show all

minusplus1. Code Editor
Arrow Keys Right/ left/ up/ down
Esc Cancel
Ctrl+Space Completion Insight
Ctrl+Shift+D Duplicate the Line
Alt+Shift+D Delete Line
Backspace/Shift+Backspace Delete Previous / Next character
Ctrl+Delete Delete to start of Next word
Ctrl+Backspace Delete to start of Previous word
Ctrl+Shift+Y Delete to end of line
Home/End Jump to beginning of line/ end of line
Ctrl+J Join Line
Ctrl+Shift+Arrow Up/Arrow Down Move line or selection up/ down
Ctrl+Arrow Right/Arrow Left Jump to Next/ Previous word
Ctrl+Arrow Down/Arrow Up Scroll line down/ up
Shift+Arrow Keys Expand selection left/ right/ up/ down
Shift+Home/End Expand selection to beginning/ end of line
Ctrl+Shift+Home/End Expand selection to beginning/ end of file
Alt+Shift+Close Brackets Expand selection to closing matching brace
Alt+Shift+Open Brackets Expand selection to opening matching brace
Ctrl+Shift+Right Arrow/ Left Arrow Expand selection to Next/ Previous word
Ctrl+2/4/8 Set Local tab to size 2/ 4/ 8
Ctrl+/ Toggle Line Comment

▲ up

minusplus2. Data Editor
Arrow Keys Left/ right/ up/ down
Alt+Enter Cell Popup
F11 Commit Changes
Ctrl+D Delete selected row(s)
Ctrl+Alt+F Filter data
Ctrl+I Insert row
Ctrl+R Refresh
F12 Rollback changes
Ctrl+Alt+S Sort

▲ up

minusplus3. DBMS Output
Ctrl+D Clear/ Delete
Ctrl+N New
Ctrl+P Print
Ctrl+S Save

▲ up

minusplus4. Debug
Shift+F8 Continue Step
Alt+F3 Find Execution Point
Ctrl+I Inspect
F9 Resume
F4 Run to Cursor
F7/Shift+F7 Step Into/ Step Out
F8 Step Over
Ctrl+F2 Terminate
F5 Toggle Breakpoint
Ctrl+F5 Watch

▲ up

minusplus5. Edit
Alt+Shift+Page Up/Page Down Add Cursor Above/ Below
Ctrl+X/Ctrl+C/Ctrl+V Cut/ Copy/ Paste
Ctrl+Shift+X/Ctrl+Shift+C/Ctrl+Shift+V Cut/ Copy/ Paste Path
Ctrl+Z/Ctrl+Y Undo/ Redo
Ctrl+A Select All

▲ up

minusplus6. File
Ctrl+O Open
Ctrl+P Print
Ctrl+Shift+F4 Save
Ctrl+F4 Close
Ctrl+Shift+F4 Close All

▲ up

minusplus7. Metrics
Shift+Home Actual Size
Ctrl+S Save Image
Arrow Keys Pan (drag) up/down/left/ right
Ctrl+Arrow Right/Ctrl+Drag Right Zoom in
Ctrl+Arrow Left/Ctrl+Drag Left Zoom out
Ctrl+Home Zoom to Fit

▲ up

minusplus8. Navigate
Alt+Arrow Left/Arrow Right Backwards/ Forwards
Open Bookmarks Bookmarks
Ctrl+Shift+09 Toggle Bookmark 09
Ctrl+09 Go to Bookmark 09
Ctrl+Shift+Backspace Go to last Edit
Ctrl+G Goto Line
Ctrl+Q/Ctrl+Shift+Q Go to Next/ Previous Bookmark
Alt+Arrow Down/Arrow Up Go to Next/ Previous Member
Alt+F8/F7 Go to Next/ Previous Message
Ctrl+= Go to Recent Files
Ctrl+Alt+M Maximize Toggle
Ctrl+'/Ctrl+Shift+' Navigate down/ up

▲ up

minusplus9. Connections
Alt+V+C Open Connections
Alt+F10 Select connection and open new worksheet.

▲ up

minusplus10. PL/SQL Editor
Ctrl+F8 Compile
Ctrl+Shift+F8 Compile for Debug
Ctrl+Shift+F10 Debug
Ctrl+F10 Run

▲ up

minusplus11. Search
Ctrl+F Find
F3/Shift+F3 Find Next/ Previous
Ctrl+F3/Ctrl+Shift+F3 Find Next/ Prevoius Word at Cursor
Ctrl+E/Ctrl+Shift+E Incremental Find Forward/ Backwards
` (grave accent) Global Search
Ctrl+R Replace

▲ up

minusplus12. Source
Ctrl+Alt+Enter Code Assist
Ctrl+Shift+[/] Collapse/ Expand All
Ctrl+[/] Collape/ Expand Block
Ctrl+Shift+Enter Complete Statement
Ctrl+Shift+=/- Expand/ Narrow Selection
Ctrl+Shift+. Focus Breadcrumbs
Ctrl+D Quick Doc
Alt+Shift+F Reformat
Ctrl+Shift+W Show Whitespace

▲ up

minusplus13. View
Ctrl+Shift+R Breakpoints
Ctrl+Shift+P Components
Ctrl+I Freeze Content
Ctrl+Shift+L Log
Ctrl+R Refresh

▲ up

minusplus14. Window
Alt+19 Activate Document 19
Alt+Shift+19 Assign to Alt+19
Alt+0 File List
Alt+Page Up/Page Down Left Editor/ Right Editor
F6/Shift+F6 Next Pane/ Previous Pane
Ctrl+Tab/Ctrl+Shift+Tab Next File/ Previous File
Shift+F5/Alt+Shift+F5 Left Tab/ Right Tab
Alt+- Show Editor Menu

▲ up

minusplus15. Worksheet
F6 Autotrace
Ctrl+D Clear
F11 Commit
F10 Explain Plan
F12 Rollback
F5 Run Script
Ctrl+Enter (or F9) Run Statement
F8 SQL History
Ctrl+F12 SQL Tuning Advisor
Alt+F10 SQL Worksheet
Ctrl+Shift+X TimesTen Index Advisor
Ctrl+Shift+N Unshared SQL Worksheet
Ctrl+' Toggle Case

▲ up

minusplus16. Other
Ctrl+Shift+F7 Embed/ Expose
Ctrl+F7 Format
Shift+F4 Popup Descrip
Shift+F10 Context Menu
Ctrl+Shift+I Properties
Ctrl+Alt+A Quick Action
Ctrl+Shift+Arrow Down/Arrow Up SQL History - append from Next/ Previous
Ctrl+Arrow Down/Arrow Up SQL History - replace with Next/ Previous
Ctrl+F11 Run File
Ctrl+Shift+F9 Build/ Make
Alt+Shift+F9 Build/ Rebuild
F1 Context Help
Ctrl+Alt+Arrow Left/Arrow Right Help Backwards/ forward

▲ up

minusplus17. Code Snippets
Type and press Ctrl+Space, or just type when autocomplete is activated (Preferences - Database - SQL Editor Code Templates)
cf CREATE FUNCTION function_name
cp CREATE PROCEDURE procedure_name
ct CREATE TABLE table ()
df DELETE FROM table WHERE
II Insert Into table VALUES ()
ssf SELECT * FROM table

▲ up

 

Sources: Standard Key Bindings


Uploaded by fajar, updated on 6/16/2017 by bernd