Code Editor
| Windows | Action | |
|---|---|---|
| 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 | Action | |
|---|---|---|
| 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 | Action | |
|---|---|---|
| Ctrl+D | Clear/ Delete | |
| Ctrl+N | New | |
| Ctrl+P | ||
| Ctrl+S | Save |
Debug
| Windows | Action | |
|---|---|---|
| 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 | Action | |
|---|---|---|
| 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 | Action | |
|---|---|---|
| Ctrl+O | Open | |
| Ctrl+P | ||
| Ctrl+Shift+F4 | Save | |
| Ctrl+F4 | Close | |
| Ctrl+Shift+F4 | Close All |
Metrics
| Windows | Action | |
|---|---|---|
| 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 |
Navigate
| Windows | Action | |
|---|---|---|
| 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 | Action | |
|---|---|---|
| Alt+V+C | Open Connections | |
| Alt+F10 | Select connection and open new worksheet. |
PL/SQL Editor
| Windows | Action | |
|---|---|---|
| Ctrl+F8 | Compile | |
| Ctrl+Shift+F8 | Compile for Debug | |
| Ctrl+Shift+F10 | Debug | |
| Ctrl+F10 | Run |
Search
| Windows | Action | |
|---|---|---|
| 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 | Action | |
|---|---|---|
| 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 | Action | |
|---|---|---|
| Ctrl+Shift+R | Breakpoints | |
| Ctrl+Shift+P | Components | |
| Ctrl+I | Freeze Content | |
| Ctrl+Shift+L | Log | |
| Ctrl+R | Refresh |
Window
| Windows | Action | |
|---|---|---|
| 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 | Action | |
|---|---|---|
| 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 | Action | |
|---|---|---|
| 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 | Action | |
|---|---|---|
| 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 |
