Shortcuts Oracle SQL Developer for Windows

We present to your attention the shortcuts for the Oracle SQL Developer for Windows which is used on the operating system Windows, in this hotkeys description 140 of the most popular and important shortcuts are offered. You can also add your changes on our portal if you consider the data insufficiently complete or add a new program from the very beginning.

Code Editor

Windows Description Edit Cancel Save & submit
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

Data Editor

Windows Description Edit Cancel Save & submit
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

DBMS Output

Windows Description Edit Cancel Save & submit
Ctrl+D Clear/ Delete
Ctrl+N New
Ctrl+P Print
Ctrl+S Save

Debug

Windows Description Edit Cancel Save & submit
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

Edit

Windows Description Edit Cancel Save & submit
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

File

Windows Description Edit Cancel Save & submit
Ctrl+O Open
Ctrl+P Print
Ctrl+Shift+F4 Save
Ctrl+F4 Close
Ctrl+Shift+F4 Close All

Metrics

Windows Description Edit Cancel Save & submit
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
Windows Description Edit Cancel Save & submit
Alt+Arrow Left/Arrow Right Backwards/ Forwards
Open Bookmarks Bookmarks
Ctrl+Shift+0…9 Toggle Bookmark 0…9
Ctrl+0…9 Go to Bookmark 0…9
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

Connections

Windows Description Edit Cancel Save & submit
Alt+V+C Open Connections
Alt+F10 Select connection and open new worksheet.

PL/SQL Editor

Windows Description Edit Cancel Save & submit
Ctrl+F8 Compile
Ctrl+Shift+F8 Compile for Debug
Ctrl+Shift+F10 Debug
Ctrl+F10 Run
Windows Description Edit Cancel Save & submit
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

Source

Windows Description Edit Cancel Save & submit
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

View

Windows Description Edit Cancel Save & submit
Ctrl+Shift+R Breakpoints
Ctrl+Shift+P Components
Ctrl+I Freeze Content
Ctrl+Shift+L Log
Ctrl+R Refresh

Window

Windows Description Edit Cancel Save & submit
Alt+1…9 Activate Document 1…9
Alt+Shift+1…9 Assign to Alt+1…9
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

Worksheet

Windows Description Edit Cancel Save & submit
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

Other

Windows Description Edit Cancel Save & submit
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

Code Snippets

Windows Description Edit Cancel Save & submit
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
~~~ The end. Thank you for watching. Add page to bookmarks CTRL + D ~~~
Date of change: 24.01.2019
Page views: 11479
*Some of the keys listed may not work in older versions of the program