Windows | Description Edit Cancel Save & submit |
---|---|
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 |
Windows | Description Edit Cancel Save & submit |
---|---|
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 |
Windows | Description Edit Cancel Save & submit |
---|---|
Ctrl+D | Clear/ Delete |
Ctrl+N | New |
Ctrl+P | |
Ctrl+S | Save |
Windows | Description Edit Cancel Save & submit |
---|---|
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 |
Windows | Description Edit Cancel Save & submit |
---|---|
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 |
Windows | Description Edit Cancel Save & submit |
---|---|
Ctrl+O | Open |
Ctrl+P | |
Ctrl+Shift+F4 | Save |
Ctrl+F4 | Close |
Ctrl+Shift+F4 | Close All |
Windows | Description Edit Cancel Save & submit |
---|---|
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 |
Windows | Description Edit Cancel Save & submit |
---|---|
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 |
Windows | Description Edit Cancel Save & submit |
---|---|
Alt+V+C | Open Connections |
Alt+F10 | Select connection and open new worksheet. |
Windows | Description Edit Cancel Save & submit |
---|---|
Ctrl+F8 | Compile |
Ctrl+Shift+F8 | Compile for Debug |
Ctrl+Shift+F10 | Debug |
Ctrl+F10 | Run |
Windows | Description Edit Cancel Save & submit |
---|---|
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 |
Windows | Description Edit Cancel Save & submit |
---|---|
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 |
Windows | Description Edit Cancel Save & submit |
---|---|
Ctrl+Shift+R | Breakpoints |
Ctrl+Shift+P | Components |
Ctrl+I | Freeze Content |
Ctrl+Shift+L | Log |
Ctrl+R | Refresh |
Windows | Description Edit Cancel Save & submit |
---|---|
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 |
Windows | Description Edit Cancel Save & submit |
---|---|
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 |
Windows | Description Edit Cancel Save & submit |
---|---|
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 |
Windows | Description Edit Cancel Save & submit |
---|---|
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 |