Chat now with support
Chat with Support

SQL Navigator for Oracle 7.4 - 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 | 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.


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

Table/View specific

Note: Preferences preceded by an asterisk (*) are applicable to team coding operations when the Team Coding preference (see Use Extract DDL Preferences) is checked.


Option Description

Include "Constraints"

* Includes any constraints for the object in the DDL.

Option Description
Disable "Constraints" *Generate DDL with constraints in a disabled state.
Include "Triggers" *Includes any triggers for the object in the DDL.
Include "Indexes" Includes any indexes for the object in the DDL.
Include "Comments" *Includes any comments for the object in the DDL.
Include "Primary Key in Table Definition" Includes the Primary Key for the table in the DDL.
Include "Synonyms" Includes any Synonyms for the object in the DDL.
Exclude Table column default values* *Excludes all default values for the object from the DDL.
Include ENCRYPTION clause Includes any encryption-related clauses (such as encryption algorithm to be used, salting and so forth) for the object in the DDL.
Include FORCE clause Select the measurement unit you want to use for specifying margin width and other print settings.
Include datatype definition for table column Include datatype definition for any columns that are of complex type.
Include Byte/Char for Table Columns Display Byte or Char as length for a column.


Option Description
Include "Storage Clause" for Partitions Includes any Partition settings from the Storage Clause for the object in the DDL.
Include "Storage Clause" for Index Partitions Includes any Index Partition settings from the Storage Clause for the object in the DDL.
Storage Clause Options Include storage clauses with either non-default values or all values in the DDL.
Include "Tablespace Name" for Partitions Includes the Tablespace names any Partition for the object in the DDL.
Include "Tablespace Name" for Index Partitions Includes the Tablespace names in any Indexed Partition for the object in the DDL.

Exclude Partition List for Local Index

Excludes Local Index Partitions for the object in the DDL.

Note: Not applicable when Include "storage Clause" for Index Partitions (above) is selected.

List Individual Hash Partitions

Selected The "individual_hash_partitions" clause will be used.
Not Selected The "hash_partitions_by_quantity" clause will be used.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating