Code Editor Keyboard Shortcuts
Right Click Over The Editing Pane
| Icon | Right Click | Keyboard Shortcut | Description |
|---|---|---|---|
 |
Cut | CTRL+X | Remove the selected text from the editing pane. Place on the Clipboard ready to Paste elsewhere. |
 |
Copy | CTRL+C | Alternative shortcut: CTRL+Insert |
 |
Paste | CTRL+V | Alternative shortcut: SHIFT+Insert |
| Nil | Select All | CTRL+A | Select all the text in the editing pane. This is usually followed by Cut or Copy. |
 |
Auto Code Completion |
CTRL+ALT+A |
Turn on/off Auto Code Completion. (Auto Code Completion) Use SHIFT+Spacebar to force code completion. |
 |
Go to Definition |
CTRL+Enter |
Open the selected object in an appropriate editor: Visual Object Editors. Errors are sent to the Output Window. |
 |
Describe Object at Cursor |
CTRL+F3 |
Open Describe. As per Object | Describe. |
|
Nil |
Toolbox | Next Page |
CTRL+ALT+N |
Scroll through the pages of the Code Editor toolbox. |
| Nil | Toolbox | Previous Page | CTRL+ALT+P | |
 |
File | New SQL Tab | CTRL+T | Open a new tab for a SQL script in the Code Editor. |
 |
File | Open File | CTRL+O | Open a file from Windows Explorer. |
 |
File | Save to File |
CTRL+S |
Save the file. This option is enabled once the file has a name. For an Untitlted tab, save the file using File | Save to File As first. |
 |
Object | New Stored Object | CTRL+N | Create a stored object. |
 |
Object | Open/Create Package Body | ALT+N | Create a body for an existing package or (object) type |
 |
Object | Execute | F9 | Opens PL/SQL Execution Console. |
 |
Object | Generate Execution Stub | SHIFT+F9 | Generate PL/SQL Stub. |
 |
Object | Save to Database | CTRL+S | Save the object to the database. |
 |
Edit | Duplicate Line | ALT+Y | |
 |
Edit | Format Text | CTRL+R | As per Tools Menu | Formatter Tools | Format Code |
 |
Edit | Comment Selection | ALT+F7 | Enclose the selected text in comments. |
 |
Edit | Uncomment Selection | CTRL+ALT+F7 | Remove comment markers from the selected text. |
 |
Edit | Jump to Matching Bracket | CTRL+] | Jump to matching Bracket. |
 |
Bookmarks | Toggle Bookmark | Ctrl+Shift+0...Ctrl+Shift+9 | Set a bookmark. The gutter margin in the Code Editor marks the bookmark. |
 |
Bookmarks | Go To Bookmark |
Ctrl+0...Ctrl+9 |
Go to the set bookmark. See also Edit | List Bookmarks ALT+B. |
 |
Split/Compare | Vertical Split |
SHIFT+ALT+F11 |
Adjust the layout of the editing pane. Select from the options to split the editing pane in half either horizontally or vertically. The content of the editing pane will be visible in both panes. You can scroll the panes independent of each other. |
 |
Split/Compare | Horizontal Split | SHIFT+F11 | |
 |
Split/Compare | No Split | SHIFT+CTRL+F11 | |
 |
Execute | Skip to Top |
SHIFT+F7 |
Execute SQL statement in Code Editor. As per Code Editor SQL |
 |
Execute | Skip to Previous | SHIFT+F8 | |
 |
Execute | Execute to End | F9 | |
 |
Execute | Execute Step | F8 | |
 |
Execute | Skip to Next | F10 | |
 |
Execute | Skip to Bottom | F11 |
PL/SQL Debugger Keyboard Shortcuts
For more information, see PL/SQL Debugger.
| Icon | Right Click | Keyboard Shortcut |
|---|---|---|
 |
PL/SQL Debugger | CTRL+ALT+S |
 |
Toggle Breakpoint | F5 |
 |
Abort Debug Session | SHIFT+CTRL+F9 |
 |
Trace Into | F7 |
 |
Step Over | F8 |
 |
Add Watch | CTRL+F5 |
 |
Trace Out | SHIFT+F8 |
 |
Run to Cursor | F4 |
| |
Stop on Exception | CTRL+ALT+X |
 |
Auto Step Over | SHIFT+CTRL+F8 |
 |
Auto Trace Into | SHIFT+CTRL+F7 |
 |
Pause Auto Stepping | ALT+P |
Further Shortcuts In The Code Editor Editing Pane
| Keyboard Shortcut | Description |
|---|---|
| CTRL+Home | Go to the top of the file |
| CTRL+End | Go to the bottom of the file |
| Home | Go to the beginning of the line |
| End | Go to the end of the line |
| CTRL+Right Arrow | Go to the next word |
| CTRL+Left Arrow | Go to the previous word |
| CTRL+I | Indent current line/selection |
| CTRL+U | Unindent current line/Selection |
| F6 | Go to the next tab |
| SHIFT+F6 | Go to the previous tab |
Further Shortcuts Viewing SQL Code Execution Results
| Keyboard Shortcut | Description |
|---|---|
| ALT+n | Following a SQL query with many result tabs, go to the result tab numbered n. |
| CTRL+F11 | Switch between the Query and Results page. |
| ALT+Enter | Edit Cell Data. |
Shortcuts In The Code Editor Toolbar
| Icon | Tool Tip | Keyboard Shortcut | Description |
|---|---|---|---|
| |
New SQL Tab | CTRL+T | Open a new tab for a SQL script in the Code Editor. |
| |
New Stored Object | CTRL+N | Create a stored object. |
| |
File | Open File | CTRL+O | Open a file from Windows Explorer. |
| |
File | Save to File |
CTRL+S |
Save the file. This option is enabled once the file has a name. For an Untitlted tab, save the file using File | Save to File As first. |
| |
Auto Code Completion |
CTRL+ALT+A |
Turn on/off Auto Code Completion. (Auto Code Completion) Use SHIFT+Spacebar to force code completion. |
| |
Split/Compare | Vertical Split |
SHIFT+ALT+F11 |
Adjust the layout of the editing pane. Select from the options to split the editing pane in half either horizontally or vertically. The content of the editing pane will be visible in both panes. You can scroll the panes independent of each other. |
| |
Split/Compare | Horizontal Split | SHIFT+F11 | |
| |
Split/Compare | No Split | SHIFT+CTRL+F11 | |
 |
SQL History |
CTRL+ALT+R |
Recall SQL statement. Open in the Toolbox: History |
| |
PL/SQL Debugger | CTRL+ALT+S | Open in the Toolbox: PL/SQL Debugger |
| |
Execute | Skip to Top |
SHIFT+F7 |
Execute SQL statement in Code Editor. As per Code Editor SQL |
| |
Execute | Skip to Previous | SHIFT+F8 | |
| |
Execute | Execute to End | F9 | |
| |
Execute | Execute Step | F8 | |
| |
Execute | Skip to Next | F10 | |
| |
Execute | Skip to Bottom | F11 | |
| |
Object | Open/Create Package Body | ALT+N | Create a body for an existing package or (object) type |
| |
Save to Database | CTRL+S | Save the object to the database. |
| |
Execute Procedure / Function | F9 | Opens PL/SQL Execution Console. |
 |
Toggle Breakpoint | F5 | Add / Remove breakpoint on the selected line of code. |
| |
PL/SQL Debugger | CTRL+ALT+S | Open in the Toolbox: PL/SQL Debugger |
| |
Abort Debug Session | SHIFT+CTRL+F9 | For more information see PL/SQL Debugger. |