Chat now with support
Chat with Support

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

General | Object Editors

| Object Editors

Object Editors

Option Description

Auto Recompile Dependents
Selected Automatically recompile dependent objects when an object is altered.
Not Selected Force a manual recompile of dependent objects based on your preference. This is the default.

Auto Recompile Invalid Only
Selected Automatically recompiles only the dependent objects that have a status of invalid.
Not Selected Force all dependent objects to recompile automatically when using the debugger feature.

Apply changes

This option specifies the conditions necessary for the Apply Changes toolbar button to be available. Select to have the button available

  • only when you have made changes to valid objects, or
  • when you have made changes to any objects (valid or invalid), or
  • available at all times.

Save on clone

Select to automatically save a cloned object without prompting.

General | Task Bar

| Task Bar

Task Bar

Option Description
Group Similar Taskbar Buttons Display buttons with similar functionality into groups.

Group Similar Taskbar Button Threshold

Specified the maximum numbers of separate items on taskbar before grouping is performed. (if the threshold is 4 and there are 4 items on the taskbar, when another window is opened, it will be grouped).

Note: Requires selection of group functionality (above).

Order Taskbar Items by Session
Selected Task bar items of one session are grouped close together followed by items of other sessions.
Not Selected All items of the same type will be grouped together regardless of their sessions.
Reverse Order of Taskbar Items When selected, new Task bar items will be populated on the left hand side.
Rotate Taskbar Item caption when vertical Horizontal / Vertical direction of Task bar item captions.
Allow Taskbar Items to expand onto multiple lines Display Task bar items on multiple lines if the current line is full.

Extract DDL

| Preferences can be changed by any user and apply to the current user only - unless otherwise stated.

Extract DDL | General

on drag & drop within DB Navigator Allow drag & drop of the extracted DDL to another database within the same DB Navigator tree. Keywords case Select the case used for keywords in the DDL. Names case Select the case used for names in the DDL. Generate comments Show pre-generated comments in the DDL. Can be helpful to identify different parts of the script. Prefix with Schema name Any Object Name that is displayed within the DDL is prefixed with the Schema Name.

Include Drop

Include the drop statement at the beginning of the DDL to drop the object first.

Option Description
Include "Cascade Constraints" with DROP  
Include "Force" with TYPE DROP Include Drop with Force in the DLL statement for type objects. Use "CREATE OR REPLACE" Add Create or Replace to the start of the object, rather than just having Create. Include "Tablespace name" Include the Tablespace name in the DDL. Include "Storage clause" (Only Non-Default Values for Partitioned Tables)* Include the Storage clause in the DDL. Include "Physical Attributes Clause"* Include the Physical Attributes clause in the DDL.

Include "Grants"*

Include the Grants in the DDL.

Option Description
Include Object Grants (for Users) Includes any object grants for users in the DDL.
Body and Spec for Packages/Objects Includes DDL for both the body and the specification when extracting from packages or objects. The package specification declares procedures, functions, cursors, and variables. The package body contains the implementation of the public procedures and functions, together with internal and private programs and variables.

Show Trigger Snapshot

The Oracle Data Dictionary stores the DDL used to create a trigger in the all_triggers_view, along with all the other trigger parameters.

Selected

SQL Navigator extracts the DDL as stored in the all_triggers_view.

Any user comments stored in the DDL are retained when extracting the DDL.

Not Selected

SQL Navigator constructs the DDL from the object’s parameters, and any user comments will not be retained.

Separator Character

Select the character to be used as the separator in the DDL. If you extract DDL for several objects, the DDL for each object will be separated using the selected separator.

Note: The '/' character is used automatically when extracting DDL for objects without stored code.

Format Output (will not include Inline Advice)

Format the DDL according to Formatting Options.

Inline advice is never included even if Tools | Formatter Tools | Enable Inline Advice is selected.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating