plgelement.sql

Oracle PL/SQL procedure generator (second generator type)

CREATE TABLE plg_element (
   plgversion NUMBER,
   oraversion NUMBER,
   name VARCHAR2(30),
   type VARCHAR2(30),
   installed CHAR(1) DEFAULT 'N' /* Y or N */,
   inst_order INTEGER,
   tabprivs VARCHAR2(60),
   hidden CHAR(1) DEFAULT 'N' /* Y or N */,
      /* means not for end user user - deprecated or internal */
   installed_on DATE,
   installed_by VARCHAR2(30),
   create_backup CHAR(1) DEFAULT 'N' /* Y or N */
   );
   
/* Contains an entry if that element has a different 
   implementation in the specified version. */

REM DROP TABLE plg_element_version;

CREATE TABLE plg_element_version (
   plgversion NUMBER,
   name VARCHAR2(30),
   part VARCHAR2(1), /* S B */
   oraversion NUMBER
   );
   
/* Contains names of package elements which have undergone
   a change which requires impact analysis. */

REM DROP TABLE plg_element_impact;

CREATE TABLE plg_element_impact (
   plgversion NUMBER,
   name VARCHAR2(30),
   partname VARCHAR2(30),
   description VARCHAR2(2000)  
   );
   
/* Descriptions of PL/Vision elements */

DROP TABLE plg_element_desc;

CREATE TABLE plg_element_desc (
   plgversion NUMBER,
   name VARCHAR2(30),
   description VARCHAR2(2000)  
   );
   
INSERT INTO plg_element_desc VALUES (
   &v_plg_version, 'P', 'Substitute for DBMS_OUTPUT.PUT_LINE');
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plg', 'Package of library-wide constants');
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plg2000', 
 'Package to assist in analyzing and repairing Year 2000-related issues in PL/SQL code');
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgAOBJ', 
 'Package encapsulation of the ALL_OBJECTS data dictionary view');
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgASRC', 
 'Package encapsulation of the ALL_SOURCE data dictionary view');
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgBIT', 
 'Provides bit manipulation capabilities'); 
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgBOOL', 
 'Conversion and translation utilities for Boolean expressions');
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgCASE', 
 'Performs case conversion of PL/SQL code');
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgCAT', 
 'Catalogues contents of PL/SQL packages'); 
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgCHR', 
 'Provides single-character related utlities and constants'); 
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgCMT', 
 'Enhancement to native COMMIT operator'); 
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgCOLS', 
 'Provides structured API to data dictionary column information');
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgCONFIG', 
 'Sets configuration information for PL/Vision');
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgCONS', 
 'Provides structured API to data dictionary constraint information');
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgCS', 
 'Provides structured API to the PL/SQL execution Call Stack');
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgDATA', 
 'Low-level package to manipulate dynamically-defined data structures');
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgDATE', 
 'Enhancements to date manipulation and conversion in PL/SQL');
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgDDD', 
 'The Data Definition Dump (reverse-engineering) utility of PL/Vision'); 
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgDYN', 
 'Useful dynamic SQL utilities'); 
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgDYN1', 
 'Useful dynamic SQL utilities involving single bind variables');
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgEXC', 
 'Infrastructure package implementing consistent error handling and logging'); 
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgFILE', 
 'Enhancements to the PL/SQL UTL_FILE package');
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgFK', 
 'Generic foreign key lookup package');
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgFKYS', 
 'Provides structured API to data dictionary foreign key information');
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgGEN', 
 'Simple code generator to create templates and starting points for development'); 
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgHASH', 
 'Encapsulation of Oracle hash algorith (DBMS_UTILITY.GET_HASH_VALUE)');
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgHLP', 
 'Utility to provide help information about stored code from SQL*Plus'); 
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgINDS', 
 'Provides structured API to data dictionary index information'); 
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgIO', 
 'Deprecated');
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgISEG', 
 'String parsing engine');
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgJOB', 
 'Job scheduling facility that improves greatly on DBMS_JOB'); 
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgLOG', 
 'Powerful, flexible logging utility'); 
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgLST', 
 'Package that allocates and maintains named lists dynamically'); 
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgMSG', 
 'Message text consolidation package (used by plgexc)'); 
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgNST', 
 'Numeric stack package'); 
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgOBJ', 
 'Encapsulation of the ALL_OBJECTS data dictionary view'); 
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgOFST', 
 'Index-by table offset utility package');
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgPKY', 
 'Provides structured API to data dictionary primary key information'); 
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgPRS', 
 'String parsing and manipulation package'); 
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgRAND', 
 'Random number generator');
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgRB', 
 'Enhancement to native ROLLBACK operator'); 
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgREP', 
 'High-language API to manipulate repositories of data'); 
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgSEG', 
 'String parsing engine for complex formats'); 
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgSTK', 
 'String stack package'); 
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgSTR', 
 'Enhancements to the basic string manipulation functions of PL/SQL'); 
INSERT INTO plg_element_desc VALUES (
   &v_plg_version, 'plgSUBST', 'String substitution package'); 
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgTAB', 
 'Pre-defines index-by table types and offers display engines for them'); 
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgTMR', 
 'Timer mechanism to track elapsed time of PL/SQL code'); 
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgTRC', 
 'Generic tracing utility (see plgxmn for more powerful implementation)'); 
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgTYPE', 
 'Package of constants and functions for PL/SQL datatypes');
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgVAR', 
 'Dynamic (by name) variable referencing and modification package'); 
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgVU', 
 'View package, replacing SHOW ERRORS and showing stored source code');
INSERT INTO plg_element_desc VALUES (&v_plg_version, 'plgXMN', 
 'Production support and execution tracing utility'); 

COMMIT;