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
ORACLE8 PLSQL程序设计_sql_code.zip_oracle pl/sql_pl sql code_pl/sql_
版权申诉
127 浏览量
2022-09-21
03:29:21
上传
评论
收藏 47KB ZIP 举报
ORACLE8 PLSQL程序设计_sql_code.zip （41个子文件） 
11LDSTD.SQL 3KB 02-RT.SQL 4KB 03-EXAMP.SQL 2KB
README.TXT 2KB 05-PACK.SQL 6KB 11-JOB.SQL 1KB 08-CC2.SQL 1KB 09-DEBUG.PC 5KB 09-RSINS.PC 4KB 04-CV2.SQL 2KB 08-CCFIN.SQL 1KB 08-DBUG1.SQL 2KB 02-INTRO.SQL 4KB 08-AG2.SQL 2KB 04-LOOP.SQL 7KB 05-RAND.SQL 2KB 06-EXAMP.SQL 8KB 08-CNTCR.SQL 1KB 08-DBUG2.SQL 1KB 04-INTRO.SQL 4KB 02-LOOPS.SQL 3KB 05-PF.SQL 9KB 08-OUTPT.SQL 1KB www.pudn.com.txt 218B 08-CC3.SQL 1KB 05-MUTAT.SQL 4KB 07-PRCMP.PC 3KB 05-PRGMA.SQL 2KB 07-OCI.C 3KB 11-DEBUG.SQL 2KB 10-EXAMP.SQL 7KB 08-MODPR.SQL 1KB 04-CV1.PC 3KB 09-DEBUG.SQL 4KB 05-TRIG.SQL 3KB 08-AVGRD.SQL 3KB 01-EXAMP.SQL 2KB TABLES.SQL 9KB 09-RSINS.SQL 1KB 11-PRINT.SQL 4KB 08-CRDLP.SQL 929B资源评论
