Advanced Oracle PL/SQL Programming with Packages

5.8. PLVddd: DDL Syntax Dump

The PLVddd (PL/Vision Dump Data Definition language) package dumps DDL syntax from a particular schema to allow you to recreate database objects easily in other schemas. See the companion disk for details (see http://examples.oreilly.com/advoracle).

5.8.1. Including the schema

PROCEDURE inclschema;

Turns on the inclusion of schema names before each created object. This is the DEFAULT position.

PROCEDURE noinclschema;

Turns off the showing of the schema names before each created object.

FUNCTION including_schema RETURN BOOLEAN;

Returns TRUE if including the schema.

5.8.2. Including the storage parameter

PROCEDURE inclsp;

Turns on the inclusion of the storage parameters after appropriate objects.

PROCEDURE noinclsp;

Turns OFF the inclusion of storage parameters after appropriate objects. This is the DEFAULT position.

FUNCTION including_sp RETURN BOOLEAN;

Function returning TRUE if storage parameters are included and FALSE if they are not.

5.8.3. Dumping the DDL

PROCEDURE tbl (owner_in IN VARCHAR2, table_in IN VARCHAR2 := '%');

Dumps DDL for tables including named column, check constraints, and storage information.

PROCEDURE idx    
   (owner_in IN VARCHAR2, 
    name_in IN VARCHAR2 := '%', 
    table_in IN VARCHAR2 := '%');

Dumps DDL for single indexes or all indexes on tables.

PROCEDURE pky    
   (owner_in IN VARCHAR2,
    name_in IN VARCHAR2 := '%', 
    table_in IN VARCHAR2 := '%');

Dumps DDL for single primary keys or all primary keys on tables.

PROCEDURE fky (owner_in ...