没有合适的资源?快使用搜索试试~ 我知道了~
首页Oracle 11g程序员指南:预编译器详解
Oracle 11g程序员指南:预编译器详解
需积分: 1 0 下载量 159 浏览量
更新于2024-07-26
收藏 4.8MB PDF 举报
《程序员指南:Oracle预编译器》是一本专为Oracle数据库(11g Release 1,11.1)程序员设计的技术参考书籍,由Deepti Kamal撰写,并得到了Jack Godwin、Tom Portfolio、Shiladitya Guha等多位专家的贡献。该书详尽介绍了Oracle数据库中预编译器的关键技术和应用,是程序员在开发过程中不可或缺的工具。
Oracle预编译器是Oracle数据库环境中的一个重要组成部分,它们允许程序员在应用程序级别对SQL语句进行预处理,从而提高性能、减少网络流量和优化数据库查询。通过使用预编译语句,系统可以在执行之前解析并存储编译结果,从而在后续调用时避免重复解析,显著提升了代码执行效率。
书中涵盖了以下关键知识点:
1. **预编译原理**:解释了预编译过程如何工作,包括SQL语句的编译、存储和复用,以及为何这对于大规模数据处理至关重要。
2. **优化策略**:介绍了如何利用预编译器优化查询性能,如减少解析开销、缓存编译结果、减少网络传输等。
3. **编程接口与语法**:讲解了如何在Java、PL/SQL等语言中有效地使用预编译语句,包括API的使用方法和最佳实践。
4. **错误处理与调试**:讨论了如何处理预编译阶段可能出现的错误,以及如何诊断和解决这些问题。
5. **兼容性与标准合规**:强调了预编译器与不同操作系统、数据库版本之间的兼容性,以及遵循的相关行业标准。
6. **案例分析与实战示例**:书中提供了丰富的实际项目案例,帮助读者理解预编译在实际开发中的应用场景。
7. **版权和许可**:提醒读者该资料受版权保护,未经许可不得进行逆向工程、拆解或反编译,除非法律另有规定或为了实现与其他独立软件的互操作性。
《程序员指南:Oracle预编译器》是一本深入浅出的资源,不仅适合专业开发人员提升技能,也是学习和理解Oracle数据库高级特性的重要参考资料。对于任何希望通过有效利用预编译技术来优化Oracle数据库性能的开发者来说,这本书是不可或缺的学习材料。
xvi
Prerequisites..................................................................................................................................... E-13
Syntax................................................................................................................................................ E-13
Keywords and Parameters............................................................................................................. E-13
Usage Notes ..................................................................................................................................... E-13
Example I.......................................................................................................................................... E-13
Example II ........................................................................................................................................ E-13
Related Topics.................................................................................................................................. E-14
DECLARE TABLE (Oracle Embedded SQL Directive).................................................................. E-14
Purpose............................................................................................................................................. E-14
Prerequisites..................................................................................................................................... E-14
Syntax................................................................................................................................................ E-14
Keywords and Parameters............................................................................................................. E-14
Usage Notes ..................................................................................................................................... E-15
Example ............................................................................................................................................ E-15
Related Topics.................................................................................................................................. E-15
DELETE (Executable Embedded SQL).............................................................................................. E-15
Purpose............................................................................................................................................. E-15
Prerequisites..................................................................................................................................... E-15
Syntax................................................................................................................................................ E-16
Keywords and Parameters............................................................................................................. E-16
Usage Notes ..................................................................................................................................... E-17
Example ............................................................................................................................................ E-17
Related Topics.................................................................................................................................. E-17
DESCRIBE (Executable Embedded SQL)......................................................................................... E-17
Purpose............................................................................................................................................. E-18
Prerequisites..................................................................................................................................... E-18
Syntax................................................................................................................................................ E-18
Keywords and Parameters............................................................................................................. E-18
Usage Notes ..................................................................................................................................... E-18
Example ............................................................................................................................................ E-18
Related Topics.................................................................................................................................. E-19
EXECUTE ... END-EXEC (Executable Embedded SQL Extension).............................................. E-19
Purpose............................................................................................................................................. E-19
Prerequisites.....................................................................................................................................
E-19
Syntax................................................................................................................................................ E-19
Keywords and Parameters............................................................................................................. E-19
Usage Notes ..................................................................................................................................... E-19
Example ............................................................................................................................................ E-20
Related Topics.................................................................................................................................. E-20
EXECUTE (Executable Embedded SQL)........................................................................................... E-20
Purpose............................................................................................................................................. E-20
Prerequisites..................................................................................................................................... E-20
Syntax................................................................................................................................................ E-20
Keywords and Parameters............................................................................................................. E-20
Usage Notes ..................................................................................................................................... E-21
Example ............................................................................................................................................ E-21
Related Topics.................................................................................................................................. E-21
xvii
EXECUTE IMMEDIATE (Executable Embedded SQL)................................................................. E-21
Purpose............................................................................................................................................. E-21
Prerequisites..................................................................................................................................... E-21
Syntax................................................................................................................................................ E-21
Keywords and Parameters............................................................................................................. E-21
Usage Notes ..................................................................................................................................... E-22
Example ............................................................................................................................................ E-22
Related Topics.................................................................................................................................. E-22
FETCH (Executable Embedded SQL)................................................................................................ E-22
Purpose............................................................................................................................................. E-22
Prerequisites..................................................................................................................................... E-22
Syntax................................................................................................................................................ E-22
Keywords and Parameters............................................................................................................. E-22
Usage Notes ..................................................................................................................................... E-23
Example ............................................................................................................................................ E-24
Related Topics.................................................................................................................................. E-24
INSERT (Executable Embedded SQL) .............................................................................................. E-24
Purpose............................................................................................................................................. E-24
Prerequisites..................................................................................................................................... E-24
Syntax................................................................................................................................................ E-25
Keywords and Parameters............................................................................................................. E-25
Usage Notes ..................................................................................................................................... E-26
Example I.......................................................................................................................................... E-26
Example II ........................................................................................................................................ E-26
Related Topics.................................................................................................................................. E-26
OPEN (Executable Embedded SQL).................................................................................................. E-26
Purpose............................................................................................................................................. E-26
Prerequisites..................................................................................................................................... E-26
Syntax................................................................................................................................................ E-27
Keywords and Parameters............................................................................................................. E-27
Usage Notes ..................................................................................................................................... E-27
Example ............................................................................................................................................ E-27
Related Topics.................................................................................................................................. E-28
PREPARE (Executable Embedded SQL)...........................................................................................
E-28
Purpose............................................................................................................................................. E-28
Prerequisites..................................................................................................................................... E-28
Syntax................................................................................................................................................ E-28
Keywords and Parameters............................................................................................................. E-28
Usage Notes ..................................................................................................................................... E-28
Example ............................................................................................................................................ E-28
Related Topics.................................................................................................................................. E-29
ROLLBACK (Executable Embedded SQL)....................................................................................... E-29
Purpose............................................................................................................................................. E-29
Prerequisites..................................................................................................................................... E-29
Syntax................................................................................................................................................ E-29
Keywords and Parameters............................................................................................................. E-29
Usage Notes ..................................................................................................................................... E-30
xviii
Example I.......................................................................................................................................... E-30
Example II ........................................................................................................................................ E-30
Distributed Transactions................................................................................................................ E-30
Example III....................................................................................................................................... E-31
Related Topics.................................................................................................................................. E-31
SAVEPOINT (Executable Embedded SQL)...................................................................................... E-31
Purpose............................................................................................................................................. E-31
Prerequisites..................................................................................................................................... E-31
Syntax................................................................................................................................................ E-31
Keywords and Parameters............................................................................................................. E-31
Usage Notes ..................................................................................................................................... E-32
Related Topics.................................................................................................................................. E-32
SELECT (Executable Embedded SQL) .............................................................................................. E-32
Purpose............................................................................................................................................. E-32
Prerequisites..................................................................................................................................... E-32
Syntax................................................................................................................................................ E-33
Keywords and Parameters............................................................................................................. E-33
Usage Notes ..................................................................................................................................... E-34
Example ............................................................................................................................................ E-34
Related Topics.................................................................................................................................. E-34
UPDATE (Executable Embedded SQL) ............................................................................................ E-34
Purpose............................................................................................................................................. E-34
Prerequisites..................................................................................................................................... E-34
Syntax................................................................................................................................................ E-35
Keywords and Parameters............................................................................................................. E-35
Usage Notes ..................................................................................................................................... E-36
Examples .......................................................................................................................................... E-36
Related Topics.................................................................................................................................. E-37
VAR (Oracle Embedded SQL Directive)........................................................................................... E-37
Purpose............................................................................................................................................. E-37
Prerequisites..................................................................................................................................... E-37
Syntax................................................................................................................................................ E-37
Keywords and Parameters............................................................................................................. E-37
Usage Notes ....................................................................................................................
................. E-37
Example ............................................................................................................................................ E-37
Related Topics.................................................................................................................................. E-38
WHENEVER (Embedded SQL Directive) ........................................................................................ E-38
Purpose............................................................................................................................................. E-38
Prerequisites..................................................................................................................................... E-38
Syntax................................................................................................................................................ E-38
Keywords and Parameters............................................................................................................. E-38
Usage Notes ..................................................................................................................................... E-39
Example ............................................................................................................................................ E-39
Related Topics.................................................................................................................................. E-39
Index
xix
List of Figures
1–1 Embedded SQL Program Development.................................................................................. 1-2
1–2 Features and Benefits.................................................................................................................. 1-4
2–1 Application Development Process ........................................................................................... 2-7
3–1 Updating the SQLCA ................................................................................................................. 3-3
3–2 Connecting through SQL*Net................................................................................................ 3-27
3–3 Hypothetical DTP Model........................................................................................................ 3-35
5–1 Maximum Cursors in Use....................................................................................................... 5-12
8–1 SQLSTATE Coding Scheme ...................................................................................................... 8-9
8–2 SQLCA Variables ..................................................................................................................... 8-16
8–3 ORACA Variables.................................................................................................................... 8-29
10–1 Choosing the Right Method ................................................................................................... 10-5
11–1 SQL*Forms ............................................................................................................................... 11-3
C–1 PL/SQL Boosts Performance ................................................................................................... C-3
C–2 Cursors Linked through the Cursor Cache............................................................................ C-7
xx
List of Tables
2–1 Embedded SQL Statements...................................................................................................... 2-2
2–2 Executable SQL Statements and their Descriptions.............................................................. 2-3
3–1 Internal Datatypes...................................................................................................................... 3-4
3–2 Pseudocolumns and Internal Datatypes................................................................................. 3-6
3–3 Parameterless Functions ........................................................................................................... 3-7
3–4 External Datatypes..................................................................................................................... 3-9
3–5 DATE Datatype Example....................................................................................................... 3-10
3–6 Conversion Between Internal and External Datatypes ..................................................... 3-16
3–7 External Datatypes Parameters............................................................................................. 3-21
3–8 VARNUM Example................................................................................................................ 3-22
3–9 Globalization Support Parameters ....................................................................................... 3-23
5–1 Legal Datatype Conversions ................................................................................................. 5-10
6–1 Precompiler Command............................................................................................................. 6-1
6–2 System Configuration File ........................................................................................................ 6-4
6–3 Precompiler Options.................................................................................................................. 6-7
6–4 DBMS and MODE Settings.................................................................................................... 6-21
6–5 File Extensions......................................................................................................................... 6-29
6–6 SQLCHECK Checking............................................................................................................ 6-44
8–1 SQLCODE Declaration.............................................................................................................. 8-4
8–2 SQLSTATE Declaration............................................................................................................. 8-5
8–3 ASSUME_SQLCODE=NO........................................................................................................ 8-5
8–4 ASSUME_SQLCODE=YES....................................................................................................... 8-7
8–5 Classes Predefined by SQL92................................................................................................... 8-9
8–6 SQLSTATE Status Codes and Oracle Errors Mapping...................................................... 8-10
8–7 Datatypes in SQLGLS Argument List.................................................................................. 8-26
8–8 Function Code for SQL Commands..................................................................................... 8-27
9–1 Valid Host Arrays Usage in a SELECT INTO Statement..................................................... 9-4
9–2 Valid Host Arrays Usage in an UPDATE Statement............................................................ 9-6
10–1
Methods and Kind of SQL Statements................................................................................. 10-3
B–1 Oracle Reserved Namespaces ................................................................................................. B-5
C–1 HOLD_CURSOR and RELEASE_CURSOR.......................................................................... C-8
E–1 Functional Summary of Embedded SQL Commands and Directives .............................. E-2
剩余323页未读,继续阅读
2023-04-07 上传
2023-06-18 上传
2023-08-08 上传
2023-09-06 上传
2023-08-02 上传
2023-07-31 上传
2023-04-01 上传
2023-08-15 上传
2023-12-06 上传
jenny_hjj
- 粉丝: 0
- 资源: 1
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- AirKiss技术详解:无线传递信息与智能家居连接
- Hibernate主键生成策略详解
- 操作系统实验:位示图法管理磁盘空闲空间
- JSON详解:数据交换的主流格式
- Win7安装Ubuntu双系统详细指南
- FPGA内部结构与工作原理探索
- 信用评分模型解析:WOE、IV与ROC
- 使用LVS+Keepalived构建高可用负载均衡集群
- 微信小程序驱动餐饮与服装业创新转型:便捷管理与低成本优势
- 机器学习入门指南:从基础到进阶
- 解决Win7 IIS配置错误500.22与0x80070032
- SQL-DFS:优化HDFS小文件存储的解决方案
- Hadoop、Hbase、Spark环境部署与主机配置详解
- Kisso:加密会话Cookie实现的单点登录SSO
- OpenCV读取与拼接多幅图像教程
- QT实战:轻松生成与解析JSON数据
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功