立即与支持人员聊天
与支持团队交流

SQL Navigator for Oracle 8.1 - User Guide

Quick Overview Working With SQL Navigator Navigation Oracle Logon Code Editor Visual Object Editors Team Coding and Version Control Systems Modules, Windows And Dialogs
Analyze Tool Auto Describe Tool Benchmark Factory Bookmarks Dialog Capture Web Output Change Logon Password Dialog Code Analysis Code Assistant Code Road Map Code Templates Code Test Database Source Code Search Dialog DB Navigator Describe Difference Viewer Edit Data ER Diagram Explain Plan Tool Export Table Find and Replace Dialog Find objects Dialog Find Recycle Bin Objects Dialog Formatting Options HTML Viewer Import HTML as PL/SQL Import Table Java Manager Job Scheduler Locate In Tree Output Window PL/SQL Profiler Profile Manager Project Manager Publish Java to PL/SQL Quick Browse Rename Object Search Knowledge Xpert Select DB Object Dialog Server Output Server Side Installation Wizard Session Browser Source Preview SQL Modeler SQL Optimizer Task Manager Web Support Configuration Dialog Wrap Code
View | Preferences About Us

Code Assistant

Drag and drop PL/SQL syntax, SQL functions, column names, and database object names into code.

 

Move a code snippet into the editor

  1. Click View Menu | Code Assistant.
  2. Click the cursor in the editor where you would like the snippet inserted.
  3. Select the code snippet in Code Assistant. Double click on the code snippet or drag it into the editor.

 

Locate a code snippet in the Code Assistant

Code Snippets are stored in catalogs. The catalogs are as follows.

Catalog Description
Syntax and Web Catalog Browse the ready-to-use library of PL/SQL syntax. The Knowledge Xpert gives SQL Navigator users a library of more than 900 pre-built PL/SQL routines that can eliminate hours of low-level coding and debugging while enhancing application performance and reliability.
PL/Vision Catalog Knowledge Xpert products are available as optional add-on modules. For more information, see Search Knowledge Xpert.

Code and SQL Catalog

Store your own frequently used SQL statements and code fragments here.

For example, you can store your frequently-used cursor declarations or variable declarations.

TIP: The catalog sorts the folders and items alphabetically by name. Use your own naming conventions or prefixes to group similar snippets together.

Syn- IF THEN ELSIF …

Syn- WHERE clause …

Syn- SQL - Correlated subquery

Etc.

 

The Code Assistant Toolbar

Icon Tool Tip Description

Add new item or node

Add a code snippet or SQL statement. Open the Add to Catalog / Edit Dialog.

Edit item or node

Edit the selected item. Open the Add to Catalog / Edit Dialog.

Note:

  • To quickly rename an item: select it in the catalog then click on it.
  • You cannot rename the top level folders in the tree.

Delete item or node

Delete the selected item.

Note: You cannot delete the top level nodes of the tree.

Paste snippet into editor

Use to paste a code snippet into an editor:

  1. Click the cursor in the editor where you would like the snippet inserted.
  2. Click Paste snippet into editor.

TIP: Alternatively drag and drop the snippet into the editor.

Show information window

Show/Hide the information pane.

The information pane shows detailed information on the selected item.

Capture code

Use to add a code snippet or SQL statement from an editor window into the catalog:

  1. Select the code in the editor window.
  2. Click Capture Code.

This opens the Add to Catalog / Edit Dialog with the selected code already inserted.

Save all catalogs to disk

Save changes.

Add to Catalog & Edit Dialogs

Add a code snippet or folder to the Code Assistant Code and SQL Catalog. Manage items in the catalog.

Field Description

Name

Make the name descriptive.

Names can be up to 35 characters long and contain uppercase letters, lowercase letters, and any of the following characters:

_ - & space < > / , ' ( ) ..

Entry Type

Select Code Snippet or Folder.

Snippet

The snippet of code.

Note: For code snippets only.

Information

The text to be displayed in the Code Assistant Information pane.

Hint

The text to be used as a hint in the status bar at the bottom of the Code Assistant window.

Image

The icon to identify the code snippet in the catalog (Generic, Function, or Procedure).

Note: For code snippets only.

Code Road Map

The Code Road Map graphically displays the complex PL/SQL interdependencies within a database.

 

Code Road Map Toolbar

Icon Tool Tip Description

New code road map

This opens the Model Code Dialog.

Clear diagram

Clear the model window. Revert to the initial start up state.

Open file

Open a saved map file (Extension: .crm).

Save file as

Save the map with a new name (Extension: .crm).

Save file

Save the map (Extension: .crm).

Save diagram as text file

Save the map as a text file.

The file consists of a list of the objects and what they reference.

For example the following might be the results of a small code map:

PROCEDURE CRM_TEST EX_PROC_1 ---> PACKAGE CRM_TEST EX_PACK_2

PROCEDURE CRM_TEST EX_PROC_1 ---> PROCEDURE CRM_TEST EX_PROC_2

PROCEDURE CRM_TEST EX_PROC_1 ---> PROCEDURE CRM_TEST EX_PROC_3

PROCEDURE CRM_TEST EX_PROC_1 ---> TABLE CRM_TEST EMP_SNAPSHOT

PROCEDURE CRM_TEST EX_PROC_1 ---> VIEW CRM_TEST SALES

The map is laid out as follows where the arrow means "calls".

OBJECT-TYPE SCHEMA OBJECT NAME --> OBJECT-TYPE SCHEMA OBJECT NAME

Save diagram as bitmap

Create a bitmap version of the map.

TIP: You could copy the image to the clipboard. Right click over the map and select Copy Image to Clipboard.

Print diagram

Print the model side of the map.

Print preview

Preview before printing.

Code road map info

Add a comment to your code map.

Collapse packages

Collapse/Expand Package View.

Icon Tool Tip Description
Collapse Packages Show/Hide referenced sub units under the object type.
Expand Packages

 

Note: Applicable to Code Type | Package as set in the Model Code Dialog.

Refresh diagram

Refresh the diagram.

Choose colors for database objects

Color code database objects.

Zoom

Zoom in or out of the model.

Previous auto layout / Next auto layout

Scroll through layouts of the Code Road Map.

 

The Code Model

The code model consists of two panels. The left panel shows a list of components in a hierarchical tree. The right panel shows a graphic model of the code. The design is similar to models created using SQL Modeler.

Hierarchical Tree Graphical Model

The hierarchical tree is organized by object type. All procedures are listed under the Procedures node, and all tables under the Tables node.

Click on an object to highlight it in the Graphical Model.

Each object listing contains the name of the object, the schema where it resides, and the type of object. For Code Type | Package in Collapse Package view, any sub units that are referenced will be included under the object type. For example:

Lines indicate where an object is dependent on another. Lines have a knob end (the referencing object) and an arrow end (the referenced object).

In this example, DISK_UTIL references the library NT_KERNEL, specifically from the function GET_DISK_FREE_SPACE. The model is in Collapse Package view.

A self-recursive reference is shown with the arrow returning back to the object, as follows:

Actions:

  • Click on an object in the tree view and the Graphic Model centers on that object.
  • Right-click on an object to display the popup menu from the Schema Browser for that object.
  • F4 performs a Describe, if SQL Navigator supports Describes on that object type.
  • Double-click an object to perform a Describe.

Actions:

  • Right-click on an object to display the popup menu from the Schema Browser for that object type.
  • F2 toggles full screen mode.
  • F4 or Double-clicking on an object performs a Describe, if SQL Navigator supports Describes on that object type.

Model Code Dialog

Select the code to map and the options to use when the code is mapped.

Field Description

Schema

The schema where the code is located.

Code Type

Select from: function, package, procedure and trigger.

Code Unit

The options depend on the Code Type selected.

Sub Unit

The various parts of the package, sorted alphabetically. The first sub unit is selected by default.

Note: Visible for Code Type | Package.

Levels to Model

The number of levels to model down from the starting object. The default is ten.

Display Mode
Option Description

Code Only

Model the code the object calls.

Display a graphical representation of the run-time, call-stack dependencies.

Code + Data

Model both the code called and data (tables, views, and so on) referenced by the object.

Display the database objects the code references and in what manner (for example, read versus write). You can also include pertinent triggers and views. Views are essentially treated as tables.

Display Options

Select as appropriate. These options affect the visual display of the map. The data in the map is not affected.

  • Expand packages and types for calls into them
  • Include triggers (for Code + Data)
  • Include views (for Code + Data)
  • Include calls to SYS-owned objects
  • Include calls to other schema PL/SQL
相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级