SQL Developer Keyboard Shortcuts
Work faster with these essential keyboard shortcuts. From running queries to formatting code, these hotkeys will boost your productivity.
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 |
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
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 |
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
Get more out of SQL Developer
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.
Download SQL Developer Free
The best free SQL IDE for Oracle, MySQL, PostgreSQL, and more.