4 PL/SQL

PL/SQL is an extension of 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.

Contact the database administrator if the PL/SQL demonstrations are not already loaded.

4.1 PL/SQL Demonstrations

The PL/SQL demo scripts do not specify full 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>

Note:

Before you run PL/SQL, ensure that the database administrator has run the necessary initialization scripts. See chapter "Creating and Upgrading a Database " in the Oracle Database Installation and Administration Guide for Fujitsu BS2000/OSD.

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

To run these demos, you must first build the demo tables with PLSQL.DEMO.PLS-EXAMPBLD.SQL and load them with PLSQL.DEMO.PLS-EXAMPLOD.SQL (under any user ID). The following example shows how to do this and run PLS-SAMPLE1:

/START-PROGRAM $ORAC1120.SQLPLUS
* user/password
SQL> @PLS-EXAMPBLD
SQL> @PLS-EXAMPLOD
SQL> @PLS-SAMPLE1

4.1.2 PL/SQL Demos for Precompilers

The demos for the precompilers are as follows:

PLSQL.DEMO.PLS-EXAMP9.PC
PLSQL.DEMO.PLS-EXAMP10.PC
PLSQL.DEMO.PLS-SAMPLE5.PC
PLSQL.DEMO.PLS-SAMPLE6.PC

Before you run the demos, ensure that the demos are compiled and linked. See Chapter 5, "Programmatic Interfaces" for more information.

Note:

You must run the RDBMS demos before running the precompiler demos.