139 Shortcuts for Oracle SQL Developer 4

Jump to: Code Editor, Data Editor, DBMS Output, Debug, Edit, File, Metrics, Navigate, Connections, PL/SQL Editor, Search, Source, View, Window, Worksheet, Other, Code Snippets

1. 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

2. 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

3. DBMS Output

Ctrl+D

Clear/ Delete

Ctrl+N

New

Ctrl+P

Print

Ctrl+S

Save

4. 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

5. 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

6. File

Ctrl+O

Open

Ctrl+P

Print

Ctrl+Shift+F4

Save

Ctrl+F4

Close

Ctrl+Shift+F4

Close All

7. 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

8. 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

9. Connections

Alt+V+C

Open Connections

Alt+F10

Select connection and open new worksheet.

10. PL/SQL Editor

Ctrl+F8

Compile

Ctrl+Shift+F8

Compile for Debug

Ctrl+Shift+F10

Debug

Ctrl+F10

Run

11. 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

12. 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

13. View

Ctrl+Shift+R

Breakpoints

Ctrl+Shift+P

Components

Ctrl+I

Freeze Content

Ctrl+Shift+L

Log

Ctrl+R

Refresh

14. 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

15. 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

16. 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

17. 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

icon

Oracle SQL Developer Shortcuts

Advertising for Consideration:

Ads for Consideration:

Related:

Please kindly review and accept Terms of Use and Cookie & Policy Policy