Oracle SQL Developer 4 (Windows)

Worksheet

Run Statement

`Ctrl` +Enter (or F9)

All hotkeys for Oracle SQL Developer 4 (Windows)

Code Editor Right/ left/ up/ down	`Arrow Keys`
Code Editor Cancel	`Esc`
Code Editor Completion Insight	`Ctrl` + `Space`
Code Editor Duplicate the Line	`Ctrl` + `Shift` + `D`
Code Editor Delete Line	`Alt` + `Shift` + `D`
Code Editor Delete Previous / Next character	`Backspace` / `Shift` + `Backspace`
Code Editor Delete to start of Next word	`Ctrl` + `Delete`
Code Editor Delete to start of Previous word	`Ctrl` + `Backspace`
Code Editor Delete to end of line	`Ctrl` + `Shift` + `Y`
Code Editor Jump to beginning of line/ end of line	`Home` / `End`
Code Editor Join Line	`Ctrl` + `J`
Code Editor Move line or selection up/ down	`Ctrl` + `Shift` + `Arrow Up` / `Arrow Down`
Code Editor Jump to Next/ Previous word	`Ctrl` + `Arrow Right` / `Arrow Left`
Code Editor Scroll line down/ up	`Ctrl` + `Arrow Down` / `Arrow Up`
Code Editor Expand selection left/ right/ up/ down	`Shift` + `Arrow Keys`
Code Editor Expand selection to beginning/ end of line	`Shift` + `Home` / `End`
Code Editor Expand selection to beginning/ end of file	`Ctrl` + `Shift` + `Home` / `End`
Code Editor Expand selection to closing matching brace	`Alt` + `Shift` +Close Brackets
Code Editor Expand selection to opening matching brace	`Alt` + `Shift` +Open Brackets
Code Editor Expand selection to Next/ Previous word	`Ctrl` + `Shift` + `Right Arrow` / `Left Arrow`
Code Editor Set Local tab to size 2/ 4/ 8	`Ctrl` + `2` / `4` / `8`
Code Editor Toggle Line Comment	`Ctrl` + `/`
Data Editor Left/ right/ up/ down	`Arrow Keys`
Data Editor Cell Popup	`Alt` + `Enter`
Data Editor Commit Changes	`F11`
Data Editor Delete selected row(s)	`Ctrl` + `D`
Data Editor Filter data	`Ctrl` + `Alt` + `F`
Data Editor Insert row	`Ctrl` + `I`
Data Editor Refresh	`Ctrl` + `R`
Data Editor Rollback changes	`F12`
Data Editor Sort	`Ctrl` + `Alt` + `S`
DBMS Output Clear/ Delete	`Ctrl` + `D`
DBMS Output New	`Ctrl` + `N`
DBMS Output Print	`Ctrl` + `P`
DBMS Output Save	`Ctrl` + `S`
Debug Continue Step	`Shift` + `F8`
Debug Find Execution Point	`Alt` + `F3`
Debug Inspect	`Ctrl` + `I`
Debug Resume	`F9`
Debug Run to Cursor	`F4`
Debug Step Into/ Step Out	`F7` / `Shift` + `F7`
Debug Step Over	`F8`
Debug Terminate	`Ctrl` + `F2`
Debug Toggle Breakpoint	`F5`
Debug Watch	`Ctrl` + `F5`
Edit Add Cursor Above/ Below	`Alt` + `Shift` + `Page Up` / `Page Down`
Edit Cut/ Copy/ Paste	`Ctrl` + `X` / `Ctrl` + `C` / `Ctrl` + `V`
Edit Cut/ Copy/ Paste Path	`Ctrl` + `Shift` + `X` / `Ctrl` + `Shift` + `C` / `Ctrl` + `Shift` + `V`
Edit Undo/ Redo	`Ctrl` + `Z` / `Ctrl` + `Y`
Edit Select All	`Ctrl` + `A`
File Open	`Ctrl` + `O`
File Print	`Ctrl` + `P`
File Save	`Ctrl` + `Shift` + `F4`
File Close	`Ctrl` + `F4`
File Close All	`Ctrl` + `Shift` + `F4`
Metrics Actual Size	`Shift` + `Home`
Metrics Save Image	`Ctrl` + `S`
Metrics Pan (drag) up/down/left/ right	`Arrow Keys`
Metrics Zoom in	`Ctrl` + `Arrow Right` / `Ctrl` +Drag Right
Metrics Zoom out	`Ctrl` + `Arrow Left` / `Ctrl` +Drag Left
Metrics Zoom to Fit	`Ctrl` + `Home`
Navigate Backwards/ Forwards	`Alt` + `Arrow Left` / `Arrow Right`
Navigate Bookmarks	Open Bookmarks
Navigate Toggle Bookmark 0…9	`Ctrl` + `Shift` + `0` … `9`
Navigate Go to Bookmark 0…9	`Ctrl` + `0` … `9`
Navigate Go to last Edit	`Ctrl` + `Shift` + `Backspace`
Navigate Goto Line	`Ctrl` + `G`
Navigate Go to Next/ Previous Bookmark	`Ctrl` + `Q` / `Ctrl` + `Shift` + `Q`
Navigate Go to Next/ Previous Member	`Alt` + `Arrow Down` / `Arrow Up`
Navigate Go to Next/ Previous Message	`Alt` + `F8` / `F7`
Navigate Go to Recent Files	`Ctrl` + `=`
Navigate Maximize Toggle	`Ctrl` + `Alt` + `M`
Navigate Navigate down/ up	`Ctrl` + `'` / `Ctrl` + `Shift` + `'`
Connections Open Connections	`Alt` + `V` + `C`
Connections Select connection and open new worksheet.	`Alt` + `F10`
PL/SQL Editor Compile	`Ctrl` + `F8`
PL/SQL Editor Compile for Debug	`Ctrl` + `Shift` + `F8`
PL/SQL Editor Debug	`Ctrl` + `Shift` + `F10`
PL/SQL Editor Run	`Ctrl` + `F10`
Search Find	`Ctrl` + `F`
Search Find Next/ Previous	`F3` / `Shift` + `F3`
Search Find Next/ Prevoius Word at Cursor	`Ctrl` + `F3` / `Ctrl` + `Shift` + `F3`
Search Incremental Find Forward/ Backwards	`Ctrl` + `E` / `Ctrl` + `Shift` + `E`
Search Global Search	` (grave accent)
Search Replace	`Ctrl` + `R`
Source Code Assist	`Ctrl` + `Alt` + `Enter`
Source Collapse/ Expand All	`Ctrl` + `Shift` + `[` / `]`
Source Collape/ Expand Block	`Ctrl` + `[` / `]`
Source Complete Statement	`Ctrl` + `Shift` + `Enter`
Source Expand/ Narrow Selection	`Ctrl` + `Shift` + `=` / `-`
Source Focus Breadcrumbs	`Ctrl` + `Shift` + `.`
Source Quick Doc	`Ctrl` + `D`
Source Reformat	`Alt` + `Shift` + `F`
Source Show Whitespace	`Ctrl` + `Shift` + `W`
View Breakpoints	`Ctrl` + `Shift` + `R`
View Components	`Ctrl` + `Shift` + `P`
View Freeze Content	`Ctrl` + `I`
View Log	`Ctrl` + `Shift` + `L`
View Refresh	`Ctrl` + `R`
Window Activate Document 1…9	`Alt` + `1` … `9`
Window Assign to Alt+1…9	`Alt` + `Shift` + `1` … `9`
Window File List	`Alt` + `0`
Window Left Editor/ Right Editor	`Alt` + `Page Up` / `Page Down`
Window Next Pane/ Previous Pane	`F6` / `Shift` + `F6`
Window Next File/ Previous File	`Ctrl` + `Tab` / `Ctrl` + `Shift` + `Tab`
Window Left Tab/ Right Tab	`Shift` + `F5` / `Alt` + `Shift` + `F5`
Window Show Editor Menu	`Alt` + `-`
Worksheet Autotrace	`F6`
Worksheet Clear	`Ctrl` + `D`
Worksheet Commit	`F11`
Worksheet Explain Plan	`F10`
Worksheet Rollback	`F12`
Worksheet Run Script	`F5`
Worksheet Run Statement	`Ctrl` +Enter (or F9)
Worksheet SQL History	`F8`
Worksheet SQL Tuning Advisor	`Ctrl` + `F12`
Worksheet SQL Worksheet	`Alt` + `F10`
Worksheet TimesTen Index Advisor	`Ctrl` + `Shift` + `X`
Worksheet Unshared SQL Worksheet	`Ctrl` + `Shift` + `N`
Worksheet Toggle Case	`Ctrl` + `'`
Other Embed/ Expose	`Ctrl` + `Shift` + `F7`
Other Format	`Ctrl` + `F7`
Other Popup Descrip	`Shift` + `F4`
Other Context Menu	`Shift` + `F10`
Other Properties	`Ctrl` + `Shift` + `I`
Other Quick Action	`Ctrl` + `Alt` + `A`
Other SQL History - append from Next/ Previous	`Ctrl` + `Shift` + `Arrow Down` / `Arrow Up`
Other SQL History - replace with Next/ Previous	`Ctrl` + `Arrow Down` / `Arrow Up`
Other Run File	`Ctrl` + `F11`
Other Build/ Make	`Ctrl` + `Shift` + `F9`
Other Build/ Rebuild	`Alt` + `Shift` + `F9`
Other Context Help	`F1`
Other Help Backwards/ forward	`Ctrl` + `Alt` + `Arrow Left` / `Arrow Right`
Code Snippets CREATE FUNCTION function_name	cf
Code Snippets CREATE PROCEDURE procedure_name	cp
Code Snippets CREATE TABLE table ()	ct
Code Snippets DELETE FROM table WHERE	df
Code Snippets Insert Into table VALUES ()	II
Code Snippets *SELECT FROM table**	ssf

Oracle SQL Developer 4 (Windows)

Worksheet

Run Statement

Ctrl +Enter (or F9)

All hotkeys for Oracle SQL Developer 4 (Windows)

Code Editor

Right/ left/ up/ down

Arrow Keys

Code Editor

Cancel

Esc

Code Editor

Completion Insight

Ctrl + Space

Code Editor

Duplicate the Line

Ctrl + Shift + D

Code Editor

Delete Line

Alt + Shift + D

Code Editor

Delete Previous / Next character

Backspace / Shift + Backspace

Code Editor

Delete to start of Next word

Ctrl + Delete

Code Editor

Delete to start of Previous word

Ctrl + Backspace

Code Editor

Delete to end of line

Ctrl + Shift + Y

Code Editor

Jump to beginning of line/ end of line

Home / End

Code Editor

Join Line

Ctrl + J

Code Editor

Move line or selection up/ down

Ctrl + Shift + Arrow Up / Arrow Down

Code Editor

Jump to Next/ Previous word

Ctrl + Arrow Right / Arrow Left

Code Editor

Scroll line down/ up

Ctrl + Arrow Down / Arrow Up

Code Editor

Expand selection left/ right/ up/ down

Shift + Arrow Keys

Code Editor

Expand selection to beginning/ end of line

Shift + Home / End

Code Editor

Expand selection to beginning/ end of file

Ctrl + Shift + Home / End

Code Editor

Expand selection to closing matching brace

Alt + Shift +Close Brackets

Code Editor

Expand selection to opening matching brace

Alt + Shift +Open Brackets

Code Editor

Expand selection to Next/ Previous word

Ctrl + Shift + Right Arrow / Left Arrow

Code Editor

Set Local tab to size 2/ 4/ 8

Ctrl + 2 / 4 / 8

Code Editor

Toggle Line Comment

Ctrl + /

Data Editor

Left/ right/ up/ down

Arrow Keys

Data Editor

Cell Popup

Alt + Enter

Data Editor

Commit Changes

F11

`Ctrl` +Enter (or F9)

`Arrow Keys`

`Esc`

`Ctrl` + `Space`

`Ctrl` + `Shift` + `D`

`Alt` + `Shift` + `D`

`Backspace` / `Shift` + `Backspace`

`Ctrl` + `Delete`

`Ctrl` + `Backspace`

`Ctrl` + `Shift` + `Y`

`Home` / `End`

`Ctrl` + `J`

`Ctrl` + `Shift` + `Arrow Up` / `Arrow Down`

`Ctrl` + `Arrow Right` / `Arrow Left`

`Ctrl` + `Arrow Down` / `Arrow Up`

`Shift` + `Arrow Keys`

`Shift` + `Home` / `End`

`Ctrl` + `Shift` + `Home` / `End`

`Alt` + `Shift` +Close Brackets

`Alt` + `Shift` +Open Brackets

`Ctrl` + `Shift` + `Right Arrow` / `Left Arrow`

`Ctrl` + `2` / `4` / `8`

`Ctrl` + `/`

`Arrow Keys`

`Alt` + `Enter`

`F11`

`Ctrl` + `D`

`Ctrl` + `Alt` + `F`

`Ctrl` + `I`

`Ctrl` + `R`

`F12`

`Ctrl` + `Alt` + `S`

`Ctrl` + `D`

`Ctrl` + `N`

`Ctrl` + `P`

`Ctrl` + `S`

`Shift` + `F8`

`Alt` + `F3`

`Ctrl` + `I`

`F9`

`F4`

`F7` / `Shift` + `F7`

`F8`

`Ctrl` + `F2`

`F5`

`Ctrl` + `F5`

`Alt` + `Shift` + `Page Up` / `Page Down`

`Ctrl` + `X` / `Ctrl` + `C` / `Ctrl` + `V`

`Ctrl` + `Shift` + `X` / `Ctrl` + `Shift` + `C` / `Ctrl` + `Shift` + `V`