Chat now with support
Chat with Support

SQL Navigator for Oracle 7.4 - Release Notes

Extract DDL | General


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

Extract DDL/MetaData

Option Description

Show this window before performing the task

Show the preferences before the DDL is extracted from the object.

<schema>, <object> File Name Prefix

Selected The default file name will be prefixed with the schema name and object name.
Not Selected The default file name will be the same as the object name.

New tab in the Code Editor for each object

Selected Show a new tab for each object that is extracted DDL.
Not Selected All the objects' extracted DDLs will be on the same tab.

Extract DDL to the same tab in the Code Editor

Selected The script is inserted into the current tab in the Code Editor.
Not Selected A new tab is created with the SQL scripts.

Extract DDL

Option Description
Extract DDL 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.


Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating