Chat now with support
Chat with Support

SQL Navigator for Oracle 7.4 - Release Notes

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.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating