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).
File | Description 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 PL/Vision tables. |
File | Description of Contents |
---|---|
*.tst | The disk contains a series of test scripts for many of the PL/Vision packages. They are generally named PKG.tst where PKG is the name of the package. Examples are PLVtrc.tst and PLVexc.tst. You can use these as a starting point for executing and trying out the PL/Vision packages. |
isnum.spp | A package containing multiple implementations of a function that returns TRUE if the string is a number, FALSE otherwise. |
isnum.tst | A test script to analyze the performance of the various functions in isnum.spp. |
lower.spp | A package used to test the conversion of code to upper- and lowercase using the PLVcase package. |
mthtotal.sf | A stored function which uses PLVfile to locate a specific line in a file and then return a value extracted from that line. |
PLVexc1.spp | The first version of PLVexc the author developed to provide high-level exception-handling capabilities. It is interesting to compare this iteration with the final version to see how the capabilities of PLVexc grew increasingly abstract and declarative. |
showasci.sql | Simple script to show the contents of the ASCII code table for the specified range of numbers. |
showhelp.all | Code used to implement a prototype for an online help mechanism. |
spiral.all | All of the different iterations of code that evolved in Chapter 3, The PL/SQL Development Spiral |
testpkg.sql | Tests the overhead required to retrieve a value from a packaged global versus a local variable. |
timerep.sql | A script that compares the performance of a string-repeating function for different implementations. |
upcexc.spp | Example of an application-specific exception-handling package built over the more generic PLVexc package. |
Copyright (c) 2000 O'Reilly & Associates. All rights reserved.
This HTML Help has been published using the chm2web software. |