Oracle PL/SQL编程指南：附带光盘内容详解
需积分: 0 108 浏览量
更新于2024-07-29
收藏 3.15MB PDF 举报
"Oracle PL SQL Programming" 是一本由O'Reilly出版的专业书籍，主要关注Oracle数据库中的过程化语言PL/SQL的编程技术。书中附带的伴侣磁盘包含了一些额外的资源和指南，帮助读者更好地理解和应用书中的概念。
本书详细讲解了PL/SQL的各种方面，包括如何安装和使用指南、调用存储过程的方法及其限制，以及Oracle提供的内置包的使用。在安装和使用指南部分，读者可以找到关于如何设置和利用这些资源以辅助学习的步骤。此外，书中的"Calling Stored Procedures from PL/SQL"章节深入探讨了从PL/SQL调用服务器端存储过程的方法，列出了使用存根与服务器通信的过程，以及在此过程中可能遇到的各种限制，如不支持服务器端PL/SQL数据类型、无法直接引用存储包变量、不能进行远程过程调用和默认参数值等。
在内置包部分，书中详细介绍了多个Oracle提供的重要包，例如DBMS_ALERT，它是一个用于异步通知的包，提供了注册、移除、清除默认设置、发送信号和等待通知等一系列方法。DBMS_AQ是Oracle的高级队列设施，包括DBMS_AQ和DBMS_AQADM两个子包，用于消息队列的管理和操作。DBMS_DDL包则提供了对数据库对象编译和分析的功能，如ALTER_COMPILE和ANALYZE_OBJECT等过程。DBMS_JOB包则是用来管理计划任务的，包含BROKEN、CHANGE和INTERVAL等过程，用于控制和调度数据库作业。
这些内容涵盖了PL/SQL编程的关键概念和技术，对于想要提升在Oracle数据库环境中编写高效、可靠代码的开发者来说，是一份非常有价值的参考资料。通过本书的学习，读者将能够熟练地运用PL/SQL来解决实际问题，创建复杂的业务逻辑，以及与Oracle数据库的各种组件进行交互。
Table of Contents
15.8.4 Restrictions on Overloading........................................................................................551
...........................................................................................................................................................................554
15.9 Forward Declarations...................................................................................................................554
...........................................................................................................................................................................556
15.10 Go Forth and Modularize!.........................................................................................................556
...........................................................................................................................................................................557
16. Packages.....................................................................................................................................................558
16.1 The Benefits of Packages.............................................................................................................559
16.1.1 Enforced Information Hiding.......................................................................................559
16.1.2 Object−Oriented Design..............................................................................................559
16.1.3 Top−Down Design.......................................................................................................559
16.1.4 Object Persistence........................................................................................................559
16.1.5 Performance Improvement..........................................................................................560
...........................................................................................................................................................................561
16.2 Overview of Package Structure...................................................................................................561
16.2.1 The Specification.........................................................................................................561
16.2.2 The Body......................................................................................................................562
16.2.3 Package Syntax............................................................................................................562
16.2.4 Public and Private Package Elements..........................................................................563
16.2.5 How to Reference Package Elements..........................................................................564
16.2.6 Quick Tour of a Package.............................................................................................565
...........................................................................................................................................................................569
16.3 The Package Specification...........................................................................................................569
16.3.1 Packages Without Bodies............................................................................................570
16.3.2 Declaring Package Cursors..........................................................................................573
...........................................................................................................................................................................575
16.4 The Package Body.......................................................................................................................575
16.4.1 Declare in Specification or Body.................................................................................575
16.4.2 Synchronize Body with Package.................................................................................576
...........................................................................................................................................................................578
16.5 Package Data................................................................................................................................578
16.5.1 Architecture of Package−Based Data..........................................................................578
16.5.2 Global Within a Single Oracle Session........................................................................579
16.5.3 Global Public Data.......................................................................................................579
16.5.4 Global Private Data......................................................................................................580
16.5.5 Providing an Interface to Global Data.........................................................................581
...........................................................................................................................................................................583
16.6 Package Initialization...................................................................................................................583
16.6.1 Drawbacks of Package Initialization...........................................................................583
16.6.2 Use Initialization Section for Complex Logic.............................................................583
16.6.3 Side Effects..................................................................................................................584
16.6.4 Load Session Data in Initialization Section.................................................................584
...........................................................................................................................................................................586
17. Calling PL/SQL Functions in SQL..........................................................................................................587
17.1 Looking at the Problem................................................................................................................587
...........................................................................................................................................................................590
17.2 Syntax for Calling Stored Functions in SQL...............................................................................590
...........................................................................................................................................................................592
[Appendix A] What's on the Companion Disk?
xv
剩余983页未读，继续阅读
377 浏览量
109 浏览量
109 浏览量
149 浏览量
2011-02-23 上传
点击了解资源详情
点击了解资源详情
点击了解资源详情
点击了解资源详情
gerry320
- 粉丝: 0
- 资源: 9
我的内容管理
展开
