O'Reilly logo

Advanced Oracle PL/SQL Programming with Packages by Steven Feuerstein

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required