Chat now with support
Chat with Support

SQL Navigator for Oracle 7.4 - Installation Notes

Edit Menu

Common text and code-editing actions.

Menu Icon Menu Name More Information
Undo Reverse the previous editing action.
Redo Reapply the previous editing action
Cut Remove selected text and place it on the clipboard
Copy Copy selected text to the clipboard
Paste Insert the clipboard contents at the cursor location.
Select All Select all text in the item being edited

Indent

Indent the current line

To increase or decrease the indent of selected text in the editor

Unindent

Unindent the current line

To increase or decrease the indent of selected text in the editor

Comment Enclose the selected text inside PL/SQL comment marks
Uncomment Remove the PL/SQL comment marks from the selected text
Upper Case Convert selected text to upper case
Lower Case Convert selected text to lower case
Convert Keywords to Upper Case Convert all keywords and reserved words in the program to uppercase
Convert Keywords to Lower Case Convert all keywords and reserved words in the program to lowercase
Open Selected Text in Code Editor Place selected text in the Code Editor
Nil Insert
Menu Icon Menu Name

More Information

File

Insert a text file at the current cursor location.

DBMS_OUTPUT.PUT_LINE(")

Insert DBMS_OUTPUT.PUT_LINE('') at the current cursor location.

This procedure displays program output after execution. For more information, see DBMS_OUTPUT.

Debug Variable

Create a debugging statement for the variable at the current cursor location.

  • The statement is copied to the clipboard.
  • Use Edit | Paste to place the statement in the code.

CRUD Matrix

Insert a CRUD (Create-Update-Delete) matrix, enclosed in comment markers, at the current cursor location in the Code Editor.

This provides a convenient method of documenting a procedure.

SQL Statement CRUD Matrix Dialog

Got to Line Move to a specific line number in the editor.
Jump to Matching Bracket Move to the other bracket within a given pair of brackets

Toggle Bookmark

Place a bookmark at the current line.

You can set up to ten bookmarks (identified numerically 0-9).

Go to Bookmark

Return to a bookmarked line in the code.

Example Scenario: Set bookmark number 1 in the DECLARE section and bookmark number 2 at your current editing location. To return to the DECLARE section press Ctrl+1. After looking at your variable or cursor declarations, return to your editing location by pressing Ctrl+2.

List Bookmarks

View / Go to / Delete bookmarked lines in the code.

Bookmarks Dialog

Open Object at Cursor

Open the database object referenced at the current cursor location.

Use to instantly find objects from stored programs or scripts, and open them in the Visual Object Editors.

Describe Object at Cursor

Show DESCRIBE information for the database object referenced at the current cursor location.

See also Describe.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating