Advanced Oracle Pl/Sql: Programming With Packages (Nutshell Handbook)
ISBN: B00006AVR6
EAN: N/A
EAN: N/A
Year: 1995
Pages: 195
Pages: 195
Authors: Steven Feuerstein, Debby Russell
| Chapter 5 PL/Vision Package Specifications |
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.
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.
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.
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.