Oracle® Database User's Guide 11g Release 2 (11.2) for Fujitsu BS2000/OSD Part Number E27507-02 |
|
|
PDF · Mobi · ePub |
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.
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>
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.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
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.