PL_SQL_CODE

所属分类:Oracle数据库
开发工具:SQL
文件大小:46KB
下载次数:54
上传日期:2005-02-24 13:26:36
上 传 者gdbbdg
说明:  《Oracle8i PL/SQL程序设计》附源码
("Oracle8i PL/SQL Programming" by source)

文件列表:
04-CV1.PC (3438, 1996-02-18)
07-OCI.C (3251, 1996-02-19)
07-PRCMP.PC (3010, 1996-02-19)
09-DEBUG.PC (4758, 1996-02-19)
09-RSINS.PC (4202, 1996-02-19)
01-EXAMP.SQL (1996, 1996-02-18)
02-INTRO.SQL (4507, 1996-02-18)
02-LOOPS.SQL (3267, 1996-02-18)
02-RT.SQL (3662, 1996-02-18)
03-EXAMP.SQL (2524, 1996-02-18)
04-CV2.SQL (2169, 1996-02-18)
04-INTRO.SQL (3938, 1996-02-18)
04-LOOP.SQL (6939, 1996-02-18)
05-MUTAT.SQL (3828, 1996-02-19)
05-PACK.SQL (6310, 1996-02-18)
05-PF.SQL (8852, 1996-02-18)
05-PRGMA.SQL (1884, 1996-02-19)
05-RAND.SQL (2379, 1996-02-18)
05-TRIG.SQL (3282, 1996-02-19)
06-EXAMP.SQL (8629, 1996-02-19)
08-AG2.SQL (1933, 1996-02-19)
08-AVGRD.SQL (2656, 1996-02-19)
08-CC2.SQL (1357, 1996-02-19)
08-CC3.SQL (1487, 1996-02-19)
08-CCFIN.SQL (1212, 1996-02-19)
08-CNTCR.SQL (1205, 1996-02-19)
08-CRDLP.SQL (929, 1996-02-19)
08-DBUG1.SQL (1580, 1996-02-19)
08-DBUG2.SQL (1040, 1996-02-19)
08-MODPR.SQL (1485, 1996-02-19)
08-OUTPT.SQL (1238, 1996-02-19)
09-DEBUG.SQL (3768, 1996-02-19)
09-RSINS.SQL (1198, 1996-02-19)
10-EXAMP.SQL (7505, 1996-02-19)
11-DEBUG.SQL (2524, 1996-02-19)
11-JOB.SQL (1127, 1996-02-19)
11LDSTD.SQL (3179, 1996-02-19)
11-PRINT.SQL (4555, 1996-02-19)
TABLES.SQL (9370, 1996-02-19)
... ...

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

近期下载者

相关文件


收藏者