SQL Navigator for Oracle 7.4 - User Guide

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.

Extract DDL | Table/View Specific

| Table/View Specific