User`s guide

4
PL/SQL 4-1
4 PL/SQL
PL/SQL is an extension to the SQL language and is used to create, store, modify,
retrieve, and manage information in an Oracle database.
This chapter supplements the Oracle Database PL/SQL Language Reference, with
operating system-specific information about the PL/SQL demonstrations.
See your database administrator if the PL/SQL demonstrations have not already been
loaded.
4.1 PL/SQL Demonstrations
The PL/SQL demo scripts do not specify fully qualified file names when including
other scripts. To include the necessary prefixes for these files, use the
ORAENV
environment variable,
SQLPATH (search path for SQL files), as shown in the following
example:
SQLPATH=$ORAC1120.PLSQL.DEMO;<other prefixes>
4.1.1 PL/SQL Demos for the Kernel
The demos for the kernel are as follows:
PLSQL.DEMO.PLS-EXAMP1.SQL
PLSQL.DEMO.PLS-EXAMP2.SQL
PLSQL.DEMO.PLS-EXAMP3.SQL
PLSQL.DEMO.PLS-EXAMP4.SQL
PLSQL.DEMO.PLS-EXAMP5.SQL
PLSQL.DEMO.PLS-EXAMP6.SQL
PLSQL.DEMO.PLS-EXAMP7.SQL
PLSQL.DEMO.PLS-EXAMP8.SQL
PLSQL.DEMO.PLS-EXAMP11.SQL
PLSQL.DEMO.PLS-EXAMP12.SQL
PLSQL.DEMO.PLS-EXAMP13.SQL
PLSQL.DEMO.PLS-EXAMP14.SQL
PLSQL.DEMO.PLS-SAMPLE1.SQL
PLSQL.DEMO.PLS-SAMPLE2.SQL
PLSQL.DEMO.PLS-SAMPLE3.SQL
PLSQL.DEMO.PLS-SAMPLE4.SQL
Note: Before you run PL/SQL, ensure that your database
administrator has run the necessary initialization scripts. Refer to the
chapter "Creating and Upgrading a Database " in the Oracle Database
Installation and Administration Guide for Fujitsu BS2000/OSD.