Advanced Oracle PL/SQL Programming with Packages

Advanced Oracle PL/SQL Programming with PackagesSearch this book
Previous: 5.7 PLVcmt: Commit ProcessingChapter 5
PL/Vision Package Specifications
Next: 5.9 PLVdyn: Dynamic SQL Operations
 

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.

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 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.


Previous: 5.7 PLVcmt: Commit ProcessingAdvanced Oracle PL/SQL Programming with PackagesNext: 5.9 PLVdyn: Dynamic SQL Operations
5.7 PLVcmt: Commit ProcessingBook Index5.9 PLVdyn: Dynamic SQL Operations

The Oracle Library Navigation

Copyright (c) 2000 O'Reilly & Associates. All rights reserved.

Library Home Oracle PL/SQL Programming, 2nd. Ed. Guide to Oracle 8i Features Oracle Built-in Packages Advanced PL/SQL Programming with Packages Oracle Web Applications Oracle PL/SQL Language Pocket Reference Oracle PL/SQL Built-ins Pocket Reference
This HTML Help has been published using the chm2web software.