User`s guide
PL/SQL Demonstrations
4-2 Oracle Database User's Guide
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 running these demos, you must ensure that these demos are compiled and
linked as described in
Chapter 5, "Programmatic Interfaces".
Note: You must run the RDBMS demos before loading the
precompiler demos.