shortcuts.spec

SQL Developer Keyboard Shortcuts

Work faster with these essential keyboard shortcuts. From running queries to formatting code, these hotkeys will boost your productivity.

~/shortcuts.spec cheat sheet

# Cheat sheet

platforms = Windows · macOS

count = 50+ shortcuts

customizable = yes # see Pro Tips section

location = Tools → Preferences → Shortcut Keys

# Most-used

run_statement = Ctrl+Enter # single query

run_script = F5 # whole worksheet

format_sql = Ctrl+F7 # beautify

describe = Shift+F4 # table info popup

// full tables below — query · editing · navigation · files

Query Shortcuts Editing Shortcuts

execution.txt

Query Execution

Run and manage your SQL queries.

Action	Windows	Mac
Run Statement (current query)	Ctrl + Enter	Cmd + Enter
Run Script (all queries)	F5	F5
Execute Explain Plan	F10	F10
Cancel Query	Ctrl + Break	Cmd + .
Commit	F11	F11
Rollback	F12	F12

editing.txt

Code Editing

Format, complete, and edit your SQL.

Action	Windows	Mac
Format SQL (beautify)	Ctrl + F7	Cmd + F7
Auto-complete	Ctrl + Space	Ctrl + Space
Toggle Comment	Ctrl + /	Cmd + /
Uppercase Selection	Ctrl + Shift + U	Cmd + Shift + U
Lowercase Selection	Ctrl + Shift + L	Cmd + Shift + L
Duplicate Line	Ctrl + Shift + D	Cmd + Shift + D
Delete Line	Ctrl + Y	Cmd + Y

navigation.txt

Navigation

Move around quickly.

Action	Windows	Mac
Go to Line	Ctrl + G	Cmd + G
Find	Ctrl + F	Cmd + F
Find and Replace	Ctrl + H	Cmd + H
Find Next	F3	Cmd + G
Go to Definition	Ctrl + Click	Cmd + Click
Switch Tabs	Ctrl + Tab	Ctrl + Tab

files.txt

File Operations

Manage worksheets and files.

Action	Windows	Mac
New Worksheet	Alt + F10	Opt + F10
Open File	Ctrl + O	Cmd + O
Save	Ctrl + S	Cmd + S
Close Tab	Ctrl + W	Cmd + W
Undo	Ctrl + Z	Cmd + Z
Redo	Ctrl + Shift + Z	Cmd + Shift + Z

pro-tips.txt

Pro Tips

Get more out of SQL Developer with these power-user habits.

Ctrl+Enter vs F5 — Ctrl+Enter runs only the statement where your cursor is. F5 runs the entire script. Use Ctrl+Enter for testing individual queries.
Quick table describe — type a table name and press Shift+F4 to instantly see its columns, indexes, and constraints in a popup.
Customize shortcuts — go to Tools → Preferences → Shortcut Keys to view all shortcuts and customize them to your preference.

~/downloads ready.sh

Apply These Shortcuts: Format Your SQL

The fastest way to test the cheat sheet is to paste messy SQL into the editor and hit Ctrl+F7. The Format SQL guide covers the rules behind what the formatter does and how to customize them per project.

// next.specformat-sql.md · Ctrl+F7

// see-alsorun-sql-script.md · F5

Format SQL Guide

See also: Run SQL Scripts · Export to CSV · Don't have it yet? Download SQL Developer