#

| Chapter 5 PL/Vision Package Specifications |

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

5.7 PLVcmt: Commit Processing |  | 5.9 PLVdyn: Dynamic SQL Operations

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