Chat now with support
Chat with Support

SQL Navigator for Oracle 7.4 - Installation Notes

Code Explorer

Make your work with packages, procedures, and functions more efficient and error-free.


Code Explorer:

  • Is based on an advanced parsing technique that understands PL/SQL syntax.
  • Displays detailed information about a package’s components, such as variables and parameters, their types, structure and cursors.
  • Highlights the packaged procedure you are currently in.
  • Supports drag-and-drop into the editor.
  • Combines information from the specification and body.
  • Distinguishes non-published procedures and functions (by icon).

Working with packages

Work with packages is fast and easy in the Code Editor with the integrated Code Explorer.

The Code Explorer graphically displays a tree-structure view of the package currently in the editor. It shows variables, parameters, record structures, types, cursors, and so on.

The tree-view is synchronized with the editing cursor in the code-editing window, so when you click any package component in the tree-view, you can see the corresponding PL/SQL code in the editing window. Likewise, as you move the cursor in the editing window, the tree-view changes to show the object corresponding to the PL/SQL code at the cursor location.

Auto Reparse

PL/SQL parsing occurs when the editor first loads objects, and in the background as the user edits the code. You can also manually trigger a full reparsing (updating of the internal symbol table) at any time by right-click and select Auto Reparse from the shortcut menu. However, when loading a really large script having this option on will slow down SQL Navigator. Hence, to avoid wasting CPU resources, you should turn this option off when editing large scripts.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating