Skip to Main Content
Advanced Oracle PL/SQL Programming with Packages
book

Advanced Oracle PL/SQL Programming with Packages

by Steven Feuerstein
October 1996
Intermediate to advanced content levelIntermediate to advanced
687 pages
16h 41m
English
O'Reilly Media, Inc.
Content preview from Advanced Oracle PL/SQL Programming with Packages

4.6. Summary of Files on Disk

The tables in this section list the scripts contained in subdirectories created by the installation procedure. These are in addition to the individual filenames of the PL/Vision packages listed earlier; note that all filenames are in dot notation, where the first component is the package name (e.g,. PLVvu.code).

4.6.1. Contents of the install Subdirectory

FileDescription of Contents
plv*.spb
Bodies of the PL/Vision packages.
plv*.sps
Specifications of the PL/Vision packages.
plvdata.sql
Creates the data structures needed to use PL/Vision. Most of this script consists of a series of INSERT statements to populate the PLV_token and PLV_token_type tables.
plvdpsyn.sql
Drops all public synonyms for PL/Vision objects.
plvdsynl
Drops all private synonyms for PL/Vision objects in a specified account.
plvgrant.sql
Grants access to all PL/Vision objects to the specified account or to PUBLIC.
plvins23.sql
Installs PL/Vision for all PL/SQL Releases 2.3 and above (the f indicates support for File I/O).
plvinst.sql
Installs PL/Vision for all PL/SQL Releases 2.2 and below.
plvinsth.sql
Installs PL/Vision online help text.
plvprem.sql
Removes all PL/Vision packages and code elements.
plvpsyn.sql
Creates public synonyms for all PL/Vision packages.
plvsize.sql
Displays the size of PL/Vision stored code by accessing the USER_OBJECT_SIZE data dictionary.
plvsyn.sql
Creates private synonyms for all PL/Vision packages for the specified account.
plvtrem.sql
Removes all ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Database 12c PL/SQL Programming

Oracle Database 12c PL/SQL Programming

Michael McLaughlin
Oracle PL/SQL for DBAs

Oracle PL/SQL for DBAs

Arup Nanda, Steven Feuerstein
Expert Oracle PL/SQL

Expert Oracle PL/SQL

Ron Hardman, Michael McLaughlin

Publisher Resources

ISBN: 1565922387Supplemental ContentCatalog PageErrata