ORACLE8 PLSQL程序设计_sql_code.zip_oracle pl/sql_pl sql code_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