Skip Headers

Oracle8i Server User's Guide
Release 3 (8.1.7) for Fujitsu Siemens Computers BS2000/OSD

Part Number A95463-01
Go To Table Of Contents
Contents
Go To Index
Index

Go to previous page Go to next page

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 Server database.

This chapter supplements the PL/SQL User's and Reference Guide, with operating system specific information about the PL/SQL demonstrations.

See your Database Administrator if the PL/SQL demonstrations have not already been loaded.

PL/SQL Demonstrations

The PL/SQL demo scripts do not specify fully qualified filenames when including other scripts. To include the necessary prefix for these files, use the ORAENV environment variable, SQLPATH (search path for SQL files) for example:

SQLPATH=$ORACL817.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 "Installing/Upgrading Oracle Server Software" in the Installation and Database Administration Guide.


PL/SQL Demos for the Kernel

The demos for the kernel are:

PLSQL.DEMO.EXAMP1.SQL
PLSQL.DEMO.EXAMP2.SQL
PLSQL.DEMO.EXAMP3.SQL
PLSQL.DEMO.EXAMP4.SQL
PLSQL.DEMO.EXAMP5.SQL
PLSQL.DEMO.EXAMP6.SQL
PLSQL.DEMO.EXAMP7.SQL
PLSQL.DEMO.EXAMP8.SQL
PLSQL.DEMO.EXAMP11.SQL
PLSQL.DEMO.EXAMP12.SQL
PLSQL.DEMO.EXAMP13.SQL
PLSQL.DEMO.EXAMP14.SQL
PLSQL.DEMO.SAMPLE1.SQL
PLSQL.DEMO.SAMPLE2.SQL
PLSQL.DEMO.SAMPLE3.SQL
PLSQL.DEMO.SAMPLE4.SQL

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

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

PL/SQL Demos for Precompilers

The demos for the precompilers are:

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

Before running these demos, they must be compiled and linked as described in the chapter "Programmatic Interfaces".


Note:

You must run the kernel demos before trying to load the precompiler demos.



Go to previous page Go to next page
Oracle
Copyright © 2001 Oracle Corporation.

All Rights Reserved.
Go To Table Of Contents
Contents
Go To Index
Index