readme.txt

《Oracle8i PL/SQL程序设计》附源码

This file contains a description of the files in this directory.
All files contain sample code from "Oracle PL/SQL Programming".

Files ending with .SQL are script files which can be run from
SQL*Plus.  Files ending with .PC are Pro*C programs.  Files ending
with .C are OCI programs.

README.TXT:   This file
TABLES.SQL:   Script which creates the sample tables
01-EXAMP.SQL: Examples from Chapter 1
02-INTRO.SQL: Introductory examples from Chapter 2
02-LOOPS.SQL: Loop examples from Chapter 2
02-RT.SQL:    Record and table examples from Chapter 2
03-EXAMP.SQL: Examples from Chapter 3
04-INTRO.SQL: Introductory examples from Chapter 4
04-LOOP.SQL:  Cursor Fetch loop examples from Chapter 4
04-CV1.PC:    Cursor Variable Example 1 from Chapter 4
04-CV2.SQL:   Cursor Variable Example 2 from Chapter 4
05-PF.SQL:    Procedure and function examples from Chapter 5
05-PACK.SQL:  Package examples from Chapter 5
05-RAND.SQL:  Random number example from Chapter 5
05-TRIG.SQL:  Trigger examples from Chapter 5
05-MUTAT.SQL: Mutating table examples from Chapter 5
05-PRGMA.SQL: PRAGMA RESTRICT_REFERENCES examples from Chapter 5
06-EXAMP.SQL: Examples from Chapter 6
07-PRCMP.PC:  Pro*C Examples from Chapter 7
07-OCI.C:     OCI Example from Chapter 7
08-AVGRD.SQL: Original version of AverageGrade from Chapter 8
08-DBUG1.SQL: First version of the Debug package from Chapter 8
08-AG2.SQL:   Second version of AverageGrade from Chapter 8
08-OUTPT.SQL: DBMS_OUPUT example from Chapter 8
08-CNTCR.SQL: Original version of CountCredits from Chapter 8
08-DBUG2.SQL: Second version of the Debug package from Chapter 8
08-CC2.SQL:   Second version of CountCredits from Chapter 8
08-CC3.SQL:   Third version of CountCredits from Chapter 8
08-CCFIN.SQL: Final version of CountCredits from Chapter 8
08-CRDLP.SQL: First version of CreditLoop from Chapter 8
08-MODPR.SQL: Modular Programming examples from Chapter 8
09-RSINS.SQL: LogRSInserts trigger from Chapter 9
09-RSINS.PC:  Pro*C daemon for the LogRSInserts trigger from Chapter 9
09-DEBUG.SQL: Debug package from Chapter 9
09-DEBUG.PC:  Pro*C daemon for the Debug package from Chapter 9
10-EXAMP.SQL: DBMS_SQL examples from Chapter 10
11-JOB.SQL:   DBMS_JOB examples from Chapter 11
11-DEBUG.SQL: Debug package from Chapter 11
11-LDSDT.SQL: Student loader example from Chapter 11
11-PRINT.SQL: Transcript printing example from Chapter 11