You can use the following keyboard shortcuts when you work with a SQL document or PL/SQL unit.
The shortcuts are the default keyboard shortcuts. You can customize all of them.
| Name | Keyboard shortcut | Description |
|---|---|---|
| Execute | F5 | Executes a query associated with the current document. |
| Execute Current Statement | F8 | Executes the current statement. |
| Name | Keyboard shortcut | Description |
|---|---|---|
| Query Profiling Mode | Ctrl+L | Runs Query Profiler. |
| Name | Keyboard shortcut | Description |
|---|---|---|
| Previous SQL | Ctrl+Shift+Up Arrow | Navigates to the previous SQL statement in the execution history. |
| Next SQL | Ctrl+Shift+Down Arrow | Navigates to the next SQL statement in the execution history. |
| SQL History | Ctrl+Alt+H | Opens the Query History document. |
| Go To Definition | F12 | Navigates to the definition of the selected object. |
| Ctrl+R | Shows or hides additional document views. | |
| Move Current Line Up/Down | Alt+Up/Down Arrow | Moves the current line up or down by one position. |
| Move Selected Line Up/Down | Alt+Up/Down Arrow | Moves the selected line up or down by one position. |
| Name | Keyboard shortcut | Description |
|---|---|---|
| Edit Parameters | Ctrl+Shift+P | Edits parameters for the current query. |
| Name | Keyboard shortcut | Description |
|---|---|---|
| List Members | Ctrl+J Ctrl+K, L |
Displays a list of members. |
| Complete Word | Ctrl+Space Ctrl+K, W Ctrl+Right Arrow |
Completes the current word. |
| Parameter Info | Ctrl+Shift+Space Ctrl+K, P |
Displays information about the parameters of the current function or procedure. |
| Insert Template | Ctrl+K Ctrl+X |
Inserts a code snippet. |
| Quick Info | Ctrl+K, I Ctrl+K Ctrl+I |
Displays a tooltip with relevant information about the identifier at the current cursor position. |
| Name | Keyboard shortcut | Description |
|---|---|---|
| Comment Selection | Ctrl+K, C | Comments out the selected lines. |
| Uncomment Selection | Ctrl+K, U | Uncomments the selected lines. |
| Name | Keyboard shortcut | Description |
|---|---|---|
| Toggle Outlining Expansion | Ctrl+M, M | Expands or collapses the currently selected region. |
| Toggle All Outlining | Ctrl+M, L | Expands or collapses all outlining regions. |
| Stop Outlining | Ctrl+M, P | Removes all outlining in the document. |