Siemens BS2000/OSD Guide de l'utilisateur télécharger pdf (Page 33)

PL/SQL 4-1

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.

1 2 ... 28 29 30 31 32 33 34 35 36 37 38 ... 79 80

Pas de commentaire

Siemens BS2000/OSD Guide de l'utilisateur Page 33