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.

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.

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.

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 IN VARCHAR2,
• name_in IN VARCHAR2 := '%',
• table_in IN VARCHAR2 := '%');
• Dumps DDL for single foreign keys or all foreign keys on tables.
• PROCEDURE syn
• (synonym_owner_in IN VARCHAR2,
• name_in IN VARCHAR2 := '%',
• object_owner_in IN VARCHAR2 := '%',
• object_in IN VARCHAR2 := '%');
• Dumps DDL for single synonyms or all synonyms for a table.
• PROCEDURE vw (owner_in IN VARCHAR2, name_in IN VARCHAR2 := '%');
• Dumps DDL for views.
• PROCEDURE trig
• (owner_in IN VARCHAR2,
• name_in IN VARCHAR2 := '%',
• table_in IN VARCHAR2 := '%');
• Dumps DDL for single triggers or all triggers on tables.
• PROCEDURE plsql (owner_in IN VARCHAR2, name_in IN
• VARCHAR2 := '%');
• Dumps DDL for PL/SQL code objects including functions, packages, package bodies, and procedures.
• PROCEDURE seq (owner_in IN VARCHAR2, name_in IN VARCHAR2 := '%');
• Dumps DDL for sequences including starting points, max/min values, etc.
• PROCEDURE schema (owner_in IN VARCHAR2, object_in IN
• VARCHAR2 := '%');
• Dumps all of the DDL related to a specified object. If the object is a table, for example, it can generate all indexes, keys, triggers, synonyms, and views for that table as well.