Oracle_数据库_计算机类_最新资料_得益网

Oracle.PL.SQL.Programming.4th

2008-11-14 16:21:11

Pages: 1198

For the past ten years, O'Reilly's Oracle PL/SQL Programming has been the bestselling book on PL/SQL, Oracle's powerful procedural language. Packed with examples and helpful recommendations, the book has helped everyone--from novices to experienced developers, and from Oracle Forms developers to database administrators--make the most of PL/SQL.

The fourth edition is a comprehensive update, adding significant new content and extending coverage to include the very latest Oracle version, Oracle Database 10g Release 2. It describes such new features as the PL/SQL optimizing compiler, conditional compilation, compile-time warnings, regular expressions, set operators for nested tables, nonsequential collections in FORALL, the programmer-defined quoting mechanism, the ability to backtrace an exception to a line number, a variety of new built-in packages, and support for IEEE 754 compliant floating-point numbers.

The new edition adds brand-new chapters on security (including encryption, row-level security, fine-grained auditing, and application contexts), file, email, and web I/O (including the built-in packages DBMS_OUTPUT, UTL_FILE, UTL_MAIL, UTL_SMTP, and UTL_HTTP) and globalization and localization.

Co-authored by the world's foremost PL/SQL authority, Steven Feuerstein, this classic reference provides language syntax, best practices, and extensive code, ranging from simple examples to complete applications--making it a must-have on your road to PL/SQL mastery. A companion web site contains many more examples and additional technical content for enhanced learning.

OCP Oracle Database 11g: New Features for Administrators Exam Guide

2008-10-02 12:26:12

A Fully Integrated Study System for OCP Exam 1Z0-050

Prepare for the Oracle Certified Professional Oracle Database 11g New Features for Administrators exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned. This authoritative guide will help you pass the test, and serve as your essential on-the-job reference. Get complete coverage of all OCP objectives for exam 1Z0-050, including:
--Installation and upgrades
--Partitioning and storage
--Intelligent infrastructure
--Diagnostics and fault management
--Performance
--Oracle Recovery Manager and Oracle Flashback
--Security
--Oracle SQL Performance Analyzer
--SQL plan management
--Automatic SQL tuning

Oracle Regular Expressions

2008-09-27 08:42:43

Oracle Regular Expressions Pocket Reference is part tutorial and part quick-reference. It's suitable for those who have never used regular expressions before, as well as those who have experience with Perl and other languages supporting regular expressions. The book describes Oracle Database 10G's support for regular expressions, including globalization support and differences between Perl's syntax and the POSIX syntax supported by Oracle 10G. It also provides a comprehensive reference, including examples, to all supported regular expression operators, functions, and error messages.

Chapter 1. Oracle Regular Expressions Pocket Reference
Section 1.1. Introduction
Section 1.2. Organization of This Book
Section 1.3. Conventions
Section 1.4. Acknowledgments
Section 1.5. Example Data
Section 1.6. Tutorial
Section 1.7. Oracle's Regular Expression Support
Section 1.8. Regular Expression Quick Reference
Section 1.9. Oracle Regular Expression Functions
Section 1.10. Oracle Regular Expression Error Messages

oracle 9i10g编程艺术

2008-09-17 12:53:28

本书是一本有关Oracle 9i和10g体系结构数据库的权威书籍，涵盖了所有最重要的Oracle体系结构特性，包括文件、内存结构和进程，锁和锁存，事务、并发和多版本，表和索引，数据类型，以及分区和并行，并充分利用具体的例子来介绍每个特性，不仅讨论了各个特性是什么，还说明了它是如何工作的，如何使用这个特性来实现软件，以及有关的常见陷阱。
本书面向从事Oracle数据库应用的所有开发人员或DBA。
无论你是程序员还是DBA，要创建和管理稳定、高质量的Oracle系统，归根结底都需要理解Oracle数据库的体系结构。
本书是讲述Oracle数据库毋庸置疑的权威指南，凝聚了世界顶尖的Oracle专家Thomas Kyte数十年的宝贵经验和大量真知灼见。书中深入地分析了Oracle数据库体系结构，包括文件、内存结构以及构成Oracle数据库和实例的底层进程，然后讨论了一些重要的数据库主题，如锁定、并发控制、事务、重做和撤销，还解释了这些内容的重要性。最后，分析了数据库中的物理结构，如表、索引和数据类型，并介绍哪些技术能最优地使用这些物理结构。
在介绍每个特性时，作者都充分利用具体的例子来说明，不仅讨论了各个特性是什么，还说明了它如何工作，如何使用它来实现软件，并涵盖了相关的常见陷阱。
目录
第1章开发成功的Oracle应用 1
1.1 我的方法 2
1.2 黑盒方法 4
1.3 开发数据库应用的正确（和不正确）方法 8
1.3.1 了解Oracle体系结构 8
1.3.2 理解并发控制 14
1.3.3 多版本 19
1.3.4 数据库独立性？ 25
1.3.5 “怎么能让应用运行得更快?” 41
1.3.6 DBA与开发人员的关系 45
1.4 小结 46
第2章体系结构概述 47
2.1 定义数据库和实例 48
2.2 SGA和后台进程 53
2.3 连接Oracle 56
2.3.1 专用服务器 56
2.3.2 共享服务器 57
2.3.3 TCP/IP连接的基本原理 58
...详细请看书籍

Troubleshooting Oracle Performance

2008-08-29 21:57:00

Oracle 好书.

What do you do when your database application isn’t running fast enough? You troubleshoot, of course. Finding the slow part of an application is often the easy part of the battle. It’s finding a solution that’s difficult. Troubleshooting Oracle Performance helps by providing a systematic approach to addressing the underlying causes of poor database application performance.

* Written for developers by an application developer who has learned by doing
* Gives a systematic approach to solving database application performance problems
* Helps you plan for performance as you would for any other application requirement

目录
PART 1 ■ ■ ■ Foundations
■CHAPTER 1 Performance Problems . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3
■CHAPTER 2 Key Concepts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13
PART 2 ■ ■ ■ Identification
■CHAPTER 3 Identifying Performance Problems . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35
PART 3 ■ ■ ■ Query Optimizer
■CHAPTER 4 System and Object Statistics . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 109
■CHAPTER 5 Configuring the Query Optimizer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 169
■CHAPTER 6 Execution Plans . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 195
■CHAPTER 7 SQL Tuning Techniques . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 247
PART 4 ■ ■ ■ Optimization
■CHAPTER 8 Parsing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 309
■CHAPTER 9 Optimizing Data Access . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 339
■CHAPTER 10 Optimizing Joins . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 409
■CHAPTER 11 Beyond Data Access and Join Optimization . . . . . . . . . . . . . . . . . . . 459
■CHAPTER 12 Optimizing the Physical Design . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 527
v
PART 5 ■ ■ ■ Appendixes
■APPENDIX A Downloadable Files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 551
■APPENDIX B Bibliography . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 563
■INDEX . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 567

PLSQLDev6.0用户指南

2008-08-03 21:10:52

PL/SQL Developer 6.0 用户指南,适合新手上路,本书是公司内部资料，所以没有出版社，没有作者。
目录
目录 3
1. 介绍.....................................8
2. 安装.....................................12
2.1 系统需求................................12
2.2 工作站安装..............................12
2.3 基于服务器安装..........................12
2.4 脚本安装................................13
2.5 卸载 PL/SQL DEVELOPER ..................13
3. 编写程序.................................14
3.1 创建程序................................14
3.2 保存程序................................15
3.3 修改程序................................16
3.4 编译程序................................16
4. 测试程序.................................18
4.1 创建测试脚本............................18
4.2 运行测试脚本............................19
4.3 变量类型................................20
4.4 保存测试脚本............................21
4.5 跟踪运行时间错误........................22
4.6 包声明和 JAVA 会话声明..................22
4.7 查看结果集..............................23
4.8 查看 DBMS_OUTPUT........................23
4.9 查看 HTP 输出...........................23
4.10 调试...................................23
4.11 跟踪运行...............................27
5. 优化.....................................29
5.1 使用解释计划窗口........................29
5.2 自动统计................................30
5.3 PL/SQL 概览图...........................31
5.4 SQL 跟踪................................32
6. 专用 SQL.................................34
6.1 使用 SQL 窗口...........................34
6.2 结果表格处理............................35
6.3 实例模式查询............................39
6.4 连接查询................................40
6.5 置换变量................................41
6.6 更新数据库..............................42
6.7 查看和编辑 XMLTYPE 列...................43
6.8 直接查询导出............................43
6.9 保存 SQL 脚本...........................43
6.10 创建标准查询...........................44
7. 命令窗口.................................45
7.1 输入 SQL 语句和命令.....................45
7.2 开发命令文件............................46
7.3 支持命令................................47
8. 创建与修改非 PL/SQL 对象.................50
8.1 表定义编辑器............................50
8.2 序列定义编辑器..........................62
8.3 同义词定义编辑器........................62
8.4 库定义编辑器............................63
8.5 目录定义编辑器..........................63
8.6 作业定义编辑器..........................64
8.7 队列定义编辑器..........................64
8.8 队列表定义编辑器........................65
8.9 用户定义编辑器..........................66
8.10 角色定义编辑器.........................69
8.11 概要文件定义编辑器.....................70
8.12 数据库连接定义编辑器...................70
9. 报告.....................................71
9.1 标准报告................................71
9.2 定制报告................................72
9.3 变量....................................73
9.4 精制版面................................77
9.5 风格库..................................84
9.6 选项....................................84
9.7 报告菜单................................86
10. 工程....................................87
10.1 创建一个新工程.........................87
10.2 保存工程...............................88
10.3 添加源文件到工程.......................88
10.4 添加数据库对象到工程...................88
10.5 用工程项目工作.........................89
10.6 编译工程...............................89
11. 任务项目................................91
11.1 创建任务项目...........................92
11.2 编辑任务项目...........................92
11.3 关闭任务项目...........................93
11.4 删除任务项目...........................93
12. 窗口、数据库会话和事务..................94
12.1 会话模式...............................94
12.2 运行于多路会话或双路会话模式...........94
13. 浏览对象................................95
13.1 使用浏览器.............................95
13.2 浏览器过滤器...........................100
13.3 浏览器文件夹...........................101
14. 首选项..................................104
14.1 ORACLE – 连接..........................105
14.2 ORACLE – 选项..........................106
14.3 ORACLE – 调试器........................107
14.4 ORACLE – 输出..........................108
14.5 ORACLE – 跟踪..........................109
14.6 ORACLE – 概览图........................109
14.7 ORACLE – 登录历史......................111
14.8 用户界面 – 选项....................... 113
14.9 用户界面 – 工具栏..................... 115
14.10 用户界面 – 浏览器.....................116
14.11 用户界面 – 编辑器.....................117
14.12 用户界面 – 字体.......................119
14.13 用户界面 – 代码助手...................120
14.14 用户界面 – 键配置.....................121
14.15 用户界面 – 外观.......................122
14.16 用户界面 – 日期/时间..................123
14.17 窗口类型 – 程序窗口...................124
14.18 窗口类型 – SQL 窗口...................126
14.19 窗口类型 – 测试窗口...................128
14.20 窗口类型 – 计划窗口...................128
14.21 工具 – 差异...........................128
14.22 工具 – 数据生成器.....................129
14.23 工具 – 任务列表.......................130
14.24 工具 – 重新调用声明...................130
14.25 文件 – 目录...........................131
14.26 文件 – 扩展名.........................132
14.27 文件 – 备份...........................133
14.28 文件 – HTML/XML.......................134
14.29 其它 – 打印...........................135
14.30 其它 – 更新与消息.....................136
14.31 首选项集..............................137
15. 工具....................................139
15.1 浏览器.................................139
15.2 查找数据库对象.........................140
15.3 编译无效对象...........................141
15.4 导出表.................................142
15.5 导入表.................................145
15.6 导出用户对象...........................147
15.7 文本导入器.............................148
15.8 数据生成器.............................151
15.9 比较用户对象...........................155
15.10 事件监视器............................157
15.11 会话..................................158
15.12 自定义工具............................159
16. 编辑器..................................165
16.1 选择功能...............................165
16.2 列选择.................................165
16.3 指引线.................................166
16.4 代码助手...............................166
16.5 重新调用语句...........................167
16.6 专用复制...............................168
16.7 前后关系敏感帮助.......................169
16.8 数据库对象弹出式菜单...................169
16.9 解释计划...............................169
16.10 宏....................................169
16.11 代码目录..............................171
16.12 代码层次..............................172
16.13 超链接导航............................172
16.14 浏览按钮..............................173
17. 大数据编辑器............................174
17.1 编辑纯文本.............................175
17.2 编辑 RTF...............................175
17.3 编辑 XML...............................176
17.4 编辑图象...............................177
17.5 编辑十六进制数据.......................177
17.6 调用外部查看器或编辑器.................179
18. 查询设计器..............................181
18.1 创建新的 SELECT 语句...................181
18.2 修改现有的SELECT 语句..................184
18.3 处理查询定义...........................184
18.4 查询设计器首选项.......................185
19. PL/SQL 美化器...........................187
19.1 定义选项...............................187
19.2 定义规则...............................188
19.3 使用美化器.............................189
20. 模板....................................190
20.1 模板窗口...............................190
20.2 使用模板...............................191
20.3 创建和修改模板.........................192
21. 窗口列表................................197
22. 授权....................................198
22.1 允许授权...............................198
22.2 定义授权...............................199
22.3 禁止授权...............................200
23. 帮助系统................................201
23.1 MS 帮助文件............................201
23.2 HTML 手册..............................201
24. 定制....................................205
24.1 首选项.................................205
24.2 窗口版面...............................205
24.3 在线文档...............................205
24.4 命令行参数.............................207
24.5 SQL、PL/SQL、命令、JAVA 和 XML 关键词..209
24.6 插件...................................209

2 Day Developer Guide for Oracle 10g XE

2008-05-30 08:00:15

This guide explains basic concepts behind development with Oracle Database Express
Edition (Oracle Database XE) and provides examples on how to use basic language
features of SQL and PL/SQL. This guide is intended to be a very basic introduction to
development and references are provided in the text to detailed information about
subjects.
This section contains the following topics:
■ Documentation Topics on page xiii
■ Audience on page xiv
■ Documentation Accessibility on page xiv
■ Related Documentation on page xiv
■ Conventions on page xv

Oracel 10g XE 2 Day DBA

2008-05-30 07:54:18

Oracle Database Express Edition (Oracle Database XE) is a free, smaller-footprint edition of Oracle Database. Oracle Database XE is easy to install and easy to manage.
With Oracle Database XE, you use an intuitive browser-based interface to:
■Administer the database
■Create tables, views, and other database objects
■Import, export, and view table data
■Run queries and SQL scripts
■Generate reports
Oracle Database XE also includes Oracle Application Express release 2.1, a declarative, graphical development environment for creating database-centric Web applications. In addition to Oracle Application Express release 2.1, you can use all the popular Oracle and third-party languages and tools to develop your Oracle Database XE applications.
Oracle Database XE also includes the following command-line utilities:
■SQL Command Line (SQL*Plus), for entering SQL and PL/SQL commands and running scripts
■SQL*Loader, for loading data into the database
■Data Pump and the Import and Export utilities for data import and export
This section contains the following topics:
■Accessing the Database Home Page on page?1-1
■Getting Help on page?1-4
■Navigating the Graphical User Interface on page?1-5

Oracle9i for Windows NT 2000数据库系统培训教程高级篇(PDG)

2008-05-03 23:19:36

Oracle9i for Windows NT 2000数据库系统培训教程高级篇(PDG)

简介：
本书深入浅出地介绍了Oracle 9i for Windows NT/2000数据库系统的高级管理技术，使读者能够快速掌握作为合格的Oracle DBA所必需的高级知识与操作技能。书中主要内容有Oracle的网络配置以及数据库备份与恢复、数据迁移工具等技术。每章后均有习题及参考答案以巩固所学知识。
本书面向Oracle中级用户。通过对本书的学习，可以使读者逐渐掌握Oracle数据库的高级应用技术。本书可作为在校学生、数据库管理与开发人员以及其他Oracle技术人员的培训教程和参考书，也可作为大专院校和培训机构的教学用书。

目录：
第一部分 Oracle网络服务结构

1.1 Oracle的网络解决方案
1.2 Oracle网络服务组件
1.3 Oracle网络连接的基本概念
1.4 Oracle网络服务的结构
1.5 本章练习

第2章服务器端网络配置

2.1 监听器的响应方式
2.2 监听器的配置
2.3 动态服务注册的配置
2.4 监听器的管理操作
2.5 本章练习

第3章客户端网络配置

3.1 命名方式配置概述
3.2 配置本地命名方式
3.3 配置主机命名方式
3.4 连接测试与故障排除
3.5 本章练习

第4章配置与应用共享服务

4.1 共享服务结构的工作机制
4.2 配置共享服务结构
4.3 应用共享服务结构
4.4 本章练习

第二部分数据库备份与恢复

第5章数据库备份与恢复概述

5.1 备份与恢复概述
5.2 备份的基本概念
5.3 恢复的基本概念
5.4 备份与恢复策略
5.5 本章练习

第6章与备份和恢复相关的结构与组件

6.1 备份与恢复结构概述
6.2 相关结构与组件的工作机制
6.3 设置数据库的归档模式
6.4 崩溃恢复的性能调整
6.5 本章练习

第7章用户自定义的数据库备份

7.1 用户自定义备份概述
7.2 获取备份所需的信息
7.3 关闭状态的备份
7.4 打开状态的备份
7.5 手工方式备份控制文件
7.6 手工方式备份归档重做日志文件
7.7 验证用户自定义备份
7.8 本章练习

第8章用户自定义的数据库恢复

8.1 用户自定义的数据库恢复概述
8.2 用户自定义的数据库修复
8.3 用户自定义的数据库的恢复
8.4 RESETLOGS选项
8.5 用户自定义恢复的范例
8.6 本章练习

第9章 Oracle恢复管理器基础

9.1 RMAN概述
9.2 RMAN的基本概念
9.3 RMAN的基本操作
9.4 本章练习

第10章基于RMAN的数据库备份

10.1 RMAN备份的基本概念
10.2 利用RMAN备份
10.3 与RMAN备份相关的其他操作与选项
10.4 本章练习

第11章基于RMAN的数据库恢复

11.1 RMAN恢复的基本概念
11.2 基本的介质恢复
11.3 用备份的控制文件恢复介质
11.4 数据库文件修复到新的位置
11.5 本章练习

第12章数据迁移工具——Export/Import

12.1 Oracle Export与Import概述
12.2 Export工具
12.3 Import工具
12.4 迁移表空间
12.5 本章练习

附录习题参考答案

附1 第1章习题答案
附2 第2章习题答案
附3 第3章习题答案
附4 第4章习题答案
附5 第5章习题答案
附6 第6章习题答案
附7 第7章习题答案
附8 第8章习题答案
附9 第9章习题答案
附10 第10章习题答案
附11 第11章习题答案
附12 第12章习题答案

Introduction to OracleSQL and PLSQL

2008-04-24 19:15:17

Student Guide-Volume 1

Authors：
Neena Kochhar
Ellen Gravina
Priya Nathan

Technical Contributors
and Reviewers：
Claire Bennet
Christa Miethaner
Tony Hickman
Sherin Nassa
Nancy Greenberg
Hazel Russell
Kenneth Goetz
Piet van Zon
Ulrike Dietrich
Helen Robertson
Thomas Nguyen
Lisa Jansson
Kuljit Jassar
Publisher
Jerry Brosnan

非常好的官方资料，E文不是很难。我在国外的公司工作时他们使用的。希望会对大家有用。oracle的全部官方资料我会议点儿一点儿上传。非常清晰。可以转换成word文件学习。

OCA Oracle Application Server 10g Administration I Study Guide

2008-03-20 00:48:49

Contents at a Glance
Introduction xxi
Assessment Test xxix
Chapter 1
Introducing Oracle Application Server 10
g
and Components 1
Chapter 2
Performing Installation Tasks 25
Chapter 3
Understanding Application Server Management Tools 87
Chapter 4
Performing HTTP Server Configuration and
Management Tasks 129
Chapter 5
Managing and Configuring OracleAS Web Cache 181
Chapter 6
Managing and Configuring OracleAS Portal 225
Chapter 7
Deploying Application Server Applications 269
Chapter 8
Managing Secure Access to the Application Server 307
Chapter 9
Managing Authentication Using Oracle Internet Directory 355
Chapter 10
Configuring and Using Single Sign-On Server and
Delegated Administration Services 391
Appendix A
Configuring the
mod_rewrite
Routine 435
Appendix B
New Features in Release 2 445
Appendix C
Creating an OracleAS Repository 451
Appendix D
Backing Up and Recovering Oracle Application Server 465
Glossary
479
Index 487

Oracle Essentials Oracle Database 11g 4th Edition

2008-03-15 18:04:48

Our main goal is to give you a foundation for using the Oracle database effectively
and efficiently. Therefore, we wrote with these principles in mind:
Focus
We’ve tried to concentrate on the most important Oracle issues. Every topic provides
a comprehensive but concise discussion of how Oracle handles an issue
and the repercussions of that action.
Brevity
One of the first decisions we made was to concentrate on principles rather than
syntax. There simply isn’t room for myriad syntax diagrams and examples in this
book.
Uniqueness
We’ve tried to make this an ideal first Oracle book for a wide spectrum of Oracle
users—but not the last! You will very likely have to refer to Oracle documentation
or other, more specific books for more details about using Oracle. However,
we hope this book will act as an accelerator for you. Using the foundation you
get from this book, youcan take detailed information from other sources and
put it to the best use.
This book is the result of more than 45 combined years of experience with Oracle
and other databases. We hope you’ll benefit from that experience.

Oracle数据库基础知识ISSUE1.0(课程资料推荐下载)

2008-03-10 10:02:39

本课程对应的产品版本为：Oracle 8.1.7。

? 掌握ORACLE数据库系统结构中物理结构、系统全局区和进程的概念
? 掌握ORACLE数据库的存储管理知识
? 掌握管理ORACLE数据库的方法
? 了解ORACLE数据库的网络应用

Oracle PL/SQL Best Practices, 2nd Edition (新版)

2008-03-07 22:34:18

Oracle PL/SQL Best Practices, 2nd Edition (新版)

Author: Steven Feuerstein
Publisher: O'Reilly Media, Inc.
Number Of Pages: 292
Publication Date: 2007-10-22
ISBN-10 / ASIN: 0596514107
ISBN-13 / EAN: 9780596514105
Binding: Paperback

In this compact book, Steven Feuerstein, widely recognized as one of the world's leading experts on the Oracle PL/SQL language, distills his many years of programming, teaching, and writing about PL/SQL into a set of best practices-recommendations for developing successful applications. Covering the latest Oracle release, Oracle Database 11g, Feuerstein has rewritten this new edition in the style of his bestselling Oracle PL/SQL Programming. The text is organized in a problem/solution format, and chronicles the programming exploits of developers at a mythical company called My Flimsy Excuse, Inc., as they write code, make mistakes, and learn from those mistakes-and each other.

This book offers practical answers to some of the hardest questions faced by PL/SQL developers, including:

What is the best way to write the SQL logic in my application code?
How should I write my packages so they can be leveraged by my entire team of developers?
How can I make sure that all my team's programs handle and record errors consistently?
Oracle PL/SQL Best Practices summarizes PL/SQL best practices in nine major categories: overall PL/SQL application development; programming standards; program testing, tracing, and debugging; variables and data structures; control logic; error handling; the use of SQL in PL/SQL; building procedures, functions, packages, and triggers; and overall program performance.

This book is a concise and entertaining guide that PL/SQL developers will turn to again and again as they seek out ways to write higher quality code and more successful applications.

"This book presents ideas that make the difference between a successful project and one that never gets off the ground. It goes beyond just listing a set of rules, and provides realistic scenarios that help the reader understand where the rules come from. This book should be required reading for any team of Oracle database professionals."

--Dwayne King, President, KRIDAN Consulting

Summary: A set of 'best practices' for developing applications
Rating: 5

Steven Feuerstein's ORACLE PL/SQL BEST PRACTICES, 2ND EDITION provides the author's years of programming, teaching and writing experiences in a set of 'best practices' for developing applications. The latest release of Oracle is covered in chapters which cover nine categories in chapters which are quick and easy to consult, arranged in a problem/solution format to reflect real-world programming examples and challenges.

Summary: A Handy Reference For Intermediate PL/SQL Programmers.
Rating: 4

This is not a text for learning PL/SQL programming. Feuerstein's PL/SQL Programming text is much more suited for that. What you have in this book is information that the author has distilled from his other works. In a way it could be considered a summary as the title might suggest. This book is a must have for the leader of an organization that is beginning to use PL/SQL. You will find what you need for your programming standards here.

In addition to good standards suggestions, the author also gives a lot of resources that are available to PL/SQL developers. One of the prime examples is utPLSQL, a unit testing tool for stored procedures and functions. The author gives numerous other web sites and tool suggestions throughout the book.

Anyone looking to increase their PL/SQL productivity should pick up this book.

Summary: Required Reading
Rating: 5

Simply put, this book should be required reading for anyone who considers themselves a professional PL/SQL developer. It is full of pearls and gems, and succinctly presents many, many programming proverbs that must be followed if developing in 0racle

Summary: Well worth the price
Rating: 5

1. I do not follow every practice in this book.
2. Only some of those I don't follow do I think I should follow.
3. All of the practices strike me as at least arguable.

It does what it sets out to do. I believe that it will help the reader use PL/SQL more effectively. In the next edition, I'd like to see a section on unit testing, using the utPLSQL system that Feuerstein is managing the development of.

Summary: Excellent resource for new or experienced PL/SQL programmers
Rating: 5

I found this book to be an excellent (re-)introduction to good programming practices in PL/SQL. After reading the first few pages a little defensively ("I don't make those sorts of mistakes do I?") I soon realised that there was much to learn in this book as well as much that I had forgotten.

This book has lead to an instant improvement in the quality of my PL/SQL code. I particularly like the Quick Reference card in the back of the book.

北大青鸟ORACLE教程

2008-02-13 11:42:10

北大青鸟ORACLE培训资料PPT

Auerbach.Publications.Oracle.11i.E-Business.Suite.From.The.Front.Lines.eBook-LiB

2008-01-31 11:34:24

This book details the steps in installing a new 11i environment, and explains the process of upgrading from a 10.7 or an 11.0.3 release; it also explores the techniques and results of migrating from one maintenance release of 11i to another.

Chapter 1 - Introducing Apps
Chapter 2 - 11i, 8i, and 9i New Features
Chapter 3 - The Surrounding Environment
Chapter 4 - Apache
Chapter 5 - JServ
Chapter 6 - Other Services
Chapter 7 - Printing
Chapter 8 - AD and Other Utilities
Chapter 9 - Installation and Migration
Chapter 10 - Patching
Chapter 11 - Cloning
Chapter 12 - Concurrent Managers and Concurrent Programs
Chapter 13 - AutoConfig, Oracle Application Manager, and Other Management Tools
Chapter 14 - Odds and Ends

Oracle PL/SQL Language Pocket Reference, 4th Edition（新版）

2008-01-30 14:16:24

Oracle PL/SQL Language Pocket Reference, 4th Edition

Author: Steven Feuerstein, Bill Pribyl, Chip Dawes
Publisher: O'Reilly Media, Inc.
Pages: 178
Publication Date: 2007-10-23
ISBN-10/ASIN: 0596514042
ISBN-13/EAN: 9780596514044
Binding: Paperback

Book description
The fourth edition of this popular pocket guide provides quick-reference information that will help you use Oracle's PL/SQL language, including the newest Oracle Database 11g features. A companion to Steven Feuerstein and Bill Pribyl's bestselling Oracle PL/SQL Programming, this concise guide boils down the most vital PL/SQL information into an accessible summary.
Full Description

The fourth edition of this popular pocket guide provides quick-reference information that will help you use Oracle's PL/SQL language, including the newest Oracle Database 11g features. It's a companion to Steven Feuerstein and Bill Pribyl's bestselling Oracle PL/SQL Programming.

This concise guide boils down the most vital PL/SQL information into an accessible summary of:
Fundamental language elements (e.g., block structure, datatypes, declarations)
Statements for program control, cursor management, and exception handling
Records, procedures, functions, triggers, and packages
Calling PL/SQL functions in SQL

Compilation options, object-oriented features, collections, and Java integration
The new edition describes such Oracle Database 11g elements as PL/SQL's function result cache, compound triggers, the CONTINUE statement, the SIMPLE_INTEGER datatype, and improvements to native compilation, regular expressions, and compiler optimization (including intra-unit inlining). In addition, this book now includes substantial new sections on Oracle's built-in functions and packages.

When you need answers quickly, the Oracle PL/SQL Language Pocket Reference will save you hours of frustration.

Oracle Database 11g SQL

2008-01-18 00:41:13

Learn to access Oracle databases through SQL statements and construct PL/SQL programs with guidance from Oracle expert, Jason Price. Published by Oracle Press, Oracle Database 11g SQL explains how to retrieve and modify database information, use SQL Plus and SQL Developer, work with database objects, write PL/SQL programs, and much more. Inside, you'll find in-depth coverage of the very latest SQL features and tools, performance optimization techniques, advanced queries, Java support, and XML. This book contains everything you need to master SQL.
Explore SQL Plus and SQL Developer
Use SQL SELECT, INSERT, UPDATE, and DELETE statements
Write PL/SQL programs
Create tables, sequences, indexes, views, and triggers
Write advanced queries containing complex analytical functions
Create database objects and collections to handle abstract data
Use large objects to handle multimedia files containing music and movies
Write Java programs to access an Oracle Database using JDBC
Tune your SQL statements to make them execute faster
Explore the XML capabilities of the Oracle Database
Master the very latest Oracle Database 11g features, such as PIVOT and UNPIVOT, flashback archives, and much more

地理信息系统建库技术及其应用

2008-01-05 13:50:41

当前地理信息系统(GIS)中地理信息的综合变得越来越重要，人们希望使花费了巨大代价所获取的基本比例尺GIS数据能派生出·多比例尺、多用途和多专题的更多有用信息，降低GIS成本，扩大GIS服务面。为此，在GIS建库之初就必须合理考虑这些问题。本书正是以解决此问题为出发点，介绍GIS建库技术并开发了一个功能强大、使用方便的基于我国12种基本比例尺的GIS建库系统——GIS建库之星，该系统可作为建立数据仓库(Warehouse)的工具。
本书共分三篇，第一篇为GIS建库系统开发与使用，主要介绍GIS建库系统的设计原理、实现方法、开发技术和使用；第二篇为城市GIS的工程实践，主要介绍中山市地理信息系统的建设及功能；第三篇介绍石油天然气系统GIS的工程实践，主要介绍GIS建库系统在大型GIS工程中的应用实践和GIS应用于生产实际的例子。
本书可作为地理信息工程专业的教材或参考书，并对从事GIS实践工作的人员很有参考价值。

Oracle Database 11g New Features

2008-01-04 13:36:31

Your Must-Have Guide to Everything New in Oracle Database 11g

Realize the full potential of Oracle Database 11g with help from the experts. Written by Robert G. Freeman, and with insightful commentary throughout from Arup Nanda, this Oracle Press guide offers full details on the architectural changes, database administration upgrades, availability and recovery revisions, security enhancements, and programming innovations. Every new and updated feature is covered and presented with screenshots, code samples, tables, and charts. Find out how to take full advantage of all the new and improved capabilities of Oracle Database 11g, including:

? New Oracle Automatic Storage Management features, such as Fast Disk Resync, Compatibility Attributes, Preferred Mirror Read, and Rolling Upgrade components

? Improved Automated Memory Management capabilities

? New database design features, such as virtual columns, tablespace encryption, and true table-level data compression

? New Database Advisors for data recovery and repair, partitioning, and streams performance

? New tuning features, such as Automatic SQL Tuning and SQL Performance Analyzer

? Enhancements to Oracle RMAN, including active database duplication and UNDO backup optimization

? Improved auditing and security capabilities

? Advanced BI, data warehousing, and partitioning features

? New SQL and PL/SQL enhancements

About the Author

Robert G. Freeman is the bestselling author of Oracle Database 10g New Features and Oracle Database 10g RMAN Backup & Recovery. He is a frequent contributor to Oracle user groups.

Oracle9i PL/SQL从入门到精通 pdf版本

2008-01-04 10:52:48

这是Oracle9i PL/SQL从入门到精通的PDF版本
【内容提要】
Oracle9i是Oracle公司于2001年推出的最新版本的大型关系型数据库管理系统,它加强了用于电子商务环境的一系列特定功能,并提供了更好的可用性、可伸缩性、安全性、可管理性的开发平台。
全书包括23章，由浅入深地介绍了PL/SQL编程及其技巧。本书在向读者介绍基本PL/SQL的同时，还融合了很多Oracle9i中才有的PL/SQL新特性。本书内容划分为三大部分，首先是基础知识，介绍了PL/SQL简介、PL/SQL基础、控制结构、SQL基本命令、Oracle内置函数、自创建过程和函数、包和异常处理等内容；第二部分为应用开发，介绍了游标技术、触发器、集合、对象、本机动态SQL以及文件读写；最后一部分为高级部分介绍了会话间通信、Oracle高级队列、作业管理、大型对象、开发Web程序以及性能优化等PL/SQL高级技术。

【目录信息】
前言
第1章 PL／SQL简介
1.1 什么是PL／SQL
1.2 PL／SQL功能特性
1.2.1 块结构
1.2.2 变量和类型
1.2.3 程序控制结构
1.2.4 游标
1.2.5 过程和函数
1.2.6 包
1.2.7 动态SQL
1.2.8 对象类型
1.2.9 集合
1.2.10 内置包
1.3 Oracle 9i的 PL／SQL新特性
1.4 使用SQL*Plus
1.5 使用SQL*Plus Worksheet
1.6 小结
1.7 练习
第2章 PL／SQL基础
2.1 PL／SQL程序结构
2.1.1 PL／SQL块的类型
2.1.2 PL／SQL块的结构
2.1.3 词法单位
2.2 变量声明
作用域和可见性
2.3 PL／SQL变量类型
2.3.1 数字型
2.3.2 字符型
2.3.3 国际化字符类型
2.3.4 LOB（大型对象）类型
2.3.5 布尔（BOOLEAN）类型
2.3.6 日期和时间间隔（Datetime和Interval）类型
2.3.7 复合类型
2.3.8 引用类型
2.3.9 用户自定义类型
2.4 数据类型转换
2.4.1 显式转换（Explicit Conversion）
2.4.2 隐式转换（Implicit Conversion）
2.4.3 隐式转换和显式转换的比较
2.5 PL／SQL表达式
2.5.1 运算符的优先级
2.5.2 字符表达式
2.5.3 布尔表达式
2.5.4 CASE表达式
2.5.5 在比较和条件语句中处理NULL值
2.6 PL／SQL运算符
2.6.1 算术运算符
2.6.2 逻辑运算符
2.6.3 比较运算符
2.6.4 字符串运算符
2.6.5 用户自定义运算符
2.7 小结
2.8 练习
第3章表和记录
3.1 表
3.2 记录
3.2.1 记录的定义
3.2.2 记录赋值
3.3 ％TYPE和％ROWTYPE
3.3.1 使用％TYPE类型
3.3.2 使用％ROWTYPE类型
3.4 伪列
3.4.1 CURRVAL和NEXTVAL伪列
3.4.2 ROWID伪列
3.4.3 ROWNUM伪列
3.5 小结
3.6 练习
第4章 PL／SQL控制结构
4.1 条件控制
4.1.1 IF－THEN语旬
4.1.2 IF－THEN－ELSE语句
4.1.3 IF－THEN－ELSIF语句
4.1.4 CASE语句
4.1.5 搜索CASE语句
4.1.6 条件语句使用指导
4.2 循环结构
4.2.1 LOOP循环
4.2.2 WHILE－LOOP循环
4.2.3 FOR循环
4.2.4 循环语句使用指导
4.3 顺序结构
4.3.1 GOTO语句
4.3.2 NULL语句
4.4 小结
4.5 练习
第5章 SQL基本命令
5.1 SQL基本命令分类
5.2 数据定义语言（DDL）
5.3 数据操纵语言（DML）
5.3.1 INSERT语句
5.3.2 SELECT语句
5.3.3 UPDATE语句
5.3.4 DELETE语句
5.3.5 LOCK TABLE命令
5.4 事务控制命令
5.4.1 SET TRANSACTION
5.4.2 COMMIT与ROLLBACK
5.4.3 SAVE POINT
5.5 会话控制命令
5.5.1 ALTER SESSION命令
5.5.2 SET ROLE命令
5.6 系统控制命令
5.7 小结
5.8 练习
第6章 Oracle内置SQL函数
6.1 错误报告（Error Reporing）函数
6.2 数值（Number）函数
6.2.1 BITAND
6.2.2 CEIL
6.2.3 FLOOR
6.2.4 SIGN
6.2.5 ROUND
6.2.6 TRUNC
6.3 字符（Character）函数
6.3.1 CONCAT
6.3.2 INSTR
6.3.3 LPAD
6.3.4 LTRIM
6.3.5 NLS_INITCAP
6.3.6 NLS_LOWER
6.3.7 NLS_UPPER
6.3.8 NLSSORT
6.3.9 REPLACE
6.3.10 SOUNDEX
6.3.11 SUBSTR
6.3.12 TRANSLATE
6.3.13 TRIM
6.4 转换（Conversion）函数
6.4.1 CONVERT
6.4.2 TO_CHAR
6.4.3 TO_CLOB
6.4.4 TO_DATE
6.4.STO_MULTI_BYTE
6.4.6 TO_SINGLE_BYTE
6.4.7 TO_ NUMBER
6.5 日期（Date）函数
6.5.1 SYSDATE函数
6.5.2 ADD_MONTHS函数
6.5.3 CURRENT_DATE函数
6.5.4 CURRENT_TIMESTAMP函数
6.5.5 DBTIMEZONE函数
6.5.6 EXTRACT函数
6.5.7 FROM_TZ函数
6.5.8 LOCALTIMESTAMP函数
6.5.9 MONTHS_BETWEEN函数
6.5.10 NEW_TIME函数
6.5.11 NEXT_DAY函数
6.5.12 NUMTODSINTERVAL函数
6.5.13 NUMTOYMINTERVAL函数
6.5.14 ROUND函数
6.5.15 SESSIONTIMEZONE函数
6.5.16 SYSTIMESTAMP函数
6.5.17 TO_DSINTERVAL函数
6.5.18 TO_TIMESTAMP函数
6.5.19 TO_TIMESTAMP_TZ函数
6.5.20 TO_YMINTERVAL函数
6.5.21 TZ_OFFSET函数
6.5.22 TRUNC函数
6.6 分组（Group）函数
6.6.1 STDDEV函数
6.6.2 VARIANCE函数
6.7 杂项（Misc）函数
6.7.1 DECODE函数
6.7.2 DUMP函数
6.7.3 GREATEST函数
6.7.4 LEAST函数
6.7.5 NVL函数
6.8 小结
6.9 练习
第7章过程与函数
7.1 使用过程
7.1.1 创建过程
7.1.2 调用过程
7.1.3 重新编译过程
7.1.4 删除过程
7.2 使用函数
7.2.1 函数的定义
7.2.2 RETURN语句
7.2.3 调用函数
7.2.4 删除函数
7.3 子程序
7.3.1 内置子程序
7.3.2 本地子程序
7.4 递归
7.5 小结
7.6 练习
第8章包
8.1 包的概念
8.2 包的规范与创建
8.2.1 使用包的优势
8.2.2 理解包规范
8.2.3 理解包体
8.3 包的调用
8.4 包的重新编译和重载
8.4.1 包的重新编译
8.4.2 包的重载
8.5 小结
8.6 练习
第9章异常处理
9.1 什么是异常
9.2 PL／SQL预定义异常
9.3 PL／SQL的异常处理结构
9.3.1 异常的触发
9.3.2 异常的传播
9.4 自定义异常
9.4.1 声明异常
9.4.2 使用编译指令EXCEPTION_INIT
9.4.3 使用RAISE_APPLICATION_ERROR
9.4.4 使用错误函数SQLCODE和SQLERRM
9.5 小结
9.6 练习
第10章游标
10.1 什么是游标
10.2 显式游标
10.2.1 声明游标
10.2.2 打开游标（OPEN CURSOR）
10.2.3 提取游标（FETCH CURSOR）
10.2.4 关闭游标（CLOSE CURSOR）
10.2.5 显式游标的属性
10.2.6 在游标中使用子查询
10.2.7 在包中使用游标
10.3 隐式游标
10.4 游标提取循环
10.4.1 基本循环（LOOP…END LOOP）
10.4.2 WHILE循环
10.4.3 FOR循环（CURSOR FOR LOOP）
10.4.4 SELECT FOR UPDATE游标
10.5 游标变量
10.5.1 声明游标变量
10.5.2 控制游标变量
10.5.3 使用游标变量的限制
10.6 小结
10.7 练习
第11章触发器
11.1 触发器
11.2 DML触发器
11.2.1 创建DML触发器
11.2.2 访问行触发器中的列值
11.2.3 条件谓词
11.3 使用DML触发器
11.3.1 维护数据完整性
11.3.2 维护修改的历史日志
11.4 系统触发器
11.4.1 创建系统触发器
11.4.2 事件属性
11.4.3 系统触发器的例子
11.5 替代触发器
11.5.1 替代触发器的创建
11.5.2 替代触发器的编写
11.5.3 视图所包括的嵌套表上的列的触发器
11.6 触发器的例外
11.6.1 在触发器体的错误条件和例外
11.6.2 触发器和处理远程的例外
11.7 小结
11.8 练习
第12章事务管理和锁定
12.1 事务管理
12.1.1 COMMIT（提交）
12.1.2 ROLLBACK（回滚）
12.1.3 SAVEPOINT（保存点）
12.1.4 SET TRANSACTION
12.1.5 分布式事务的管理
12.1.6 RELEASE
12.2 锁定
12.2.1 表锁定
12.2.2 锁定记录
12.2.3 显式的锁定
12.2.4 其他的锁定
12.2.5 DBMS_LOCK包
12.3 小结
12.4 练习
第13章集合
13.1 集合概述
13.2 索引表
13.2.1 定义索引表
13.2.2 向索引表中插入数据
13.2.3 引用索引表的值
13.3 嵌套表
13.3.1 声明嵌套表
13.3.2 嵌套表的初始化和赋值
13.3.3 数据库中的嵌套表
13.4 变长数组
13.4.1 定义变长数组
13.4.2 初始化变长数组
13.4.3 数据库中的数组
13.5 使用集合方法
13.5.1 EXISTS方法
13.5.2 COUNT方法
13.5.3 LIMIT方法
13.5.4 FIRST和LAST方法
13.5.5 PRIOR和NEXT方法
13.5.6 EXTED方法
13.5.7 DELETE和TRIM方法
13.5.8 把方法用于集合参数
13.6 集合的异常处理
13.7 批联编
13.7.1 使用FORALL语句
13.7.2 使用BULK COLLECT
13.8 小结
13.9 练习
第14章 PL／SQL对象类型
14.1 面向对象的基本概念
14.1.1 对象（Object）
14.1.2 类（Class）
14.1.3 继承（Inheritance）
14.1.4 多态性
14.2 对象类型
14.2.1 为什么使用对象
14.2.2 对象类型的结构
14.2.3 对象类型的组成
14.3 定义对象类型
14.3.1 对象类型的定义
14.3.2 SELF参数
14.3.3 PL／SQL的继承
14.3.4 更改和删除对象类型
14.4 声明并初始化对象
14.4.1 声明对象
14.4.2 构造函数与初始化对象
14.5 对象的使用
14.5.1 存取属性
14.5.2 调用构造函数
14.5.3 调用方法
14.6 按列存储对象
14.7 对象表
14.7.1 创建对象表
14.7.2 向对象表中添加对象
14.7.3 检索对象表中的对象
14.7.4 更新对象表
14.7.5 删除对象表的对象
14.8 共享对象
14.8.1 引用
14.8.2 REF和DEREF函数
14.8.3 前期类型定义
14.9 比较对象
14.9.1 MAP方法
14.9.2 ORDER方法
14.9.3 指导要点
14.10 小结
14.11 练习
第15章跟踪和调试
15.1 调试语法错误
15.2 调试逻辑错误
15.2.1 逻辑错误例子
15.2.2 逻辑错误解决
15.3 使用工具调试程序
15.3.1 在程序中插入调试用表
15.3.2 DBMS_OUTPUT包
15.4 程序的规划与代码编写
15.4.1 程序结构的规划
15.4.2 编制代码
15.4.3 格式化代码
15.5 小结
15.6 练习
第16章本机动态SQL
16.1 什么是动态SQL
16.2 动态SQL的两种方法
16.3 使用EXECUTE IMMEDIATE语句
16.3.1 执行DDL
16.3.2 执行PL／SQL块
16.3.3 绑定变量
16.4 使用OPEN－FOR、FETCH和CLOSE语句
16.5 使用批动态SQL
16.5.1 批EXECUTE IMMEDIATE
16.5.2 批FETCH
16.5.3 批FORALL
16.6 动态SQL的技巧
16.6.1 改进性能
16.6.2 使用重复的占位符
16.6.3 使用游标属性
16.6.4 传递Null参数
16.6.5 远程操作
16.6.6 使用调用者特权
16.6.7 避免死锁
16.7 小结
16.8 练习
第17章输入与输出
17.1 DBMS_OUTPUT包
17.1.1 使用DBMS_OUTPUT包
17.1.2 启用DBMS_OUTPUT包
17.1.3 关闭DBMS_OUTPUT包
17.1.4 将数据写到缓冲区
17.1.5 从缓冲区中读取数据
17.1.6 应用举例
17.2 UTL_FILE包
17.2.1 安全性
17.2.2 使用UTL_FILE包函数与文件I／O步骤
17.2.3 UTL_FILE引发的异常
17.2.4 文件的打开与关闭
17.2.5 文件输出
17.2.6 文件输入
17.3 小结
17.4 练习
第18章会话间通信
18.1 DBMS_SESSION
18.1.1 SET_IDENTIFIER
18.1.2 SET_CONTEXT
18.1.3 CLEAR_CONTEXT
18.1.4 CLEAR_IDENTIFIER
18.1.5 SET_ROLE
18.1.6 SET_SQL_TRACE
18.1.7 SET_NLS
18.1.8 CLOSE_DATABASE_LINK
18.1.9 RESET_PACKAGE
18.1.10 UNIQUE_SESSION_ID函数
18.1.11 IS_ROLE_ENABLED函数
18.1.12 IS_SESSION_ALIVE函数
18.1.13 SET_CLOSE_CACHED_OPEN_CURSORS
18.1.14 FREE_UNUSED_USER_MEMORY
18.1.15 LIST_CONTEXT
18.1.16 SWITCH_CURRENT_CONSUMER_GROUP
18.2 DBMS_ALERT
18.2.1 包DBMS_ALERT中常量的定义
18.2.2 常见错误
18.2.3 报警使用机制
18.2.4 检查报警
18.2.5 DBMS_ALERT子程序的概述
18.3 DBMS_PIPE
18.3.1 公有管道和私有管道
18.3.2 DBMS_PIPE子程序的概述
18.4 小结
18.5 练习
第19章高级队列
19.1 高级队列简介
19.1.1 异步消息通知
19.1.2 监听功能
19.1.3 传播特征
19.1.4 队列监视
19.2 队列使用
19.2.1 为负载定义一个类型
19.2.2 CREATE_QUEUE_TABLE
19.2.3 ALTER_QUEUE_TABLE
19.2.4 DROP_QUEUE_TABLE
19.2.5 CREATE_QUEUE
19.2.6 CREATE_NP_QUEUE
19.2.7 ALTER_QUEUE
19.2.8 DROP_QUEUE
19.2.9 START_QUEUE
19.2.10 STOP_QUEUE
19.2.11 ENQUEUE
19.2.12 DEQUEUE
19.2.13 Message Properties
19.2.14 记录ENQUEUE_OPTIONS_T
19.2.15 AQ＄_AGENT对象类型
19.2.16 AQ＄_RECIPIENT_LIST_T对象类型
19.2.17 Dequeue Options Type
19.3 其他AQ过程
19.3.1 GRANT_SYSTEM_PRIVILEGE
19.3.2 REVOKE_SYSTEM_PRIVILEGE
19.3.3 GRANT_QUEUE_PRIVILEGE
19.3.4 REVOKE_QUEUE_PRIVILEGE
19.4 AQ中级知识
19.4.1 订阅者列表和接收者列表
19.4.2 订阅者列表
19.4.3 接收者列表
19.4.4 AQ执??发布/订阅
19.4.5 AQ Recipient List Type（接收者列表数据类型）
19.4.6 AQ Agent List Type（代理列表类型）
19.4.7 AQ Subscriber List Type（订阅者列表类型）
19.4.8 AQ Registration Info Type（AQ注册信息类型）
19.4.9 AQ Registration Info List Type
19.4.10 LISTEN过程
19.4.11 REGISTER过程
19.4.12 UNREGISTER过程
19.4.13 ADD_SUBSCRIBER过程
19.4.14 ALTER_SUBSCRIBER过程
19.4.15 REMOVE_SUBSCRIBER过程
19.4.16 SCHEDULE_PROPAGATION过程
19.4.17 UNSCHEDULE_PROPAGATION过程
19.4.18 VERIFY_QUEUE_TYPES过程
19.4.19 ALTER_PROPAGATION_SCHEDULE过程
19.4.20 ENABLE_PROPAGATION_SCHEDULE过程
19.4.21 DISABLE_PROPAGATION_SCHEDULE过程
19.5 AQ实例
19.5.1 创建队列表和队列
19.5.2 消息入队出队
19.5.3 消息传播
19.5.4 删除AQ对象
19.6 小结
19.7 练习
第20章数据库作业管理
20.1 如何运行作业
20.2 管理作业队列
20.2.1 DBMS_JOB包
20.2.2 作业环境（Job Environment）
20.2.3 作业的导入导出（Import/Export）
20.3 小结
20.4 练习
第21章大型对象
21.1 大型对象类型概述
21.1.1 什么是大型对象
21.1.2 大型对象数据类型
21.1.3 可变宽度（Varying－Width）字符数据
21.1.4 大型对象值和定位器
21.1.5 创建包含大型对象的表
21.2 Oracle 9i中大型对象的新特征
21.3 用PL／SQL的DBMS_上OB包
21.3.1 DBMS_LOB包函数／过程介绍
21.3.2 DBMS_LOB包的大型对象定位器
21.3.3 DBMS_LOB包的数据类型常数及异常
21.3.4 DBMS_LOB包的规则和限制
21.4 使用外部大型对象BFILE
21.4.1 创建目录对象
21.4.2 打开BFILE
21.4.3 函数FILEISOPEN
21.4.4 函数FILEEXISTS
21.4.5 关闭文件的过程
21.4.6 获得文件信息
21.4.7 读文件操作
21.4.8 比较两个文件内容
21.4.9 INSTR函数
21.4.10 SUBSTR函数
21.5 使用外部大型对象BFILE的范例
21.6 使用内部大型对象
21.6.1 APPEND过程
21.6.2 COMPARE函数
21.6.3 COPY过程
21.6.4 EMPTY_BLOB和EMPTY_CLOB函数
21.6.5 ERASE过程
21.6.6 GETLENGTH函数
21.6.7 INSTR函数
21.6.8 READ过程
21.6.9 SUBSTR函数
21.6.10 TRIM过程
21.6 11 WRITE过程
21.6.12 WRITEAPPEND过程
21.7 使用内部大型对象的范例
21.7.1 向内部LOB拷贝数据
21.7.2 向内部LOB中添加数据
21.7.3 分析内部LOB内容
21.7.4 编辑内部LOB对象
21.8 临时大型对象
21.8.1 临时大型对象概述
21.8.2 临时大型对象的使用
21.9 LONG与LOB数据类型
21.9.1 LONG与LOB数据类型的比较
21.9.2 LONG与LOB数据类型的转换
21.10 小结
21.11 练习
第22章开发Web应用程序
22.1 PL／SQL Web应用程序概念
22.1.1 使用PL／SQL存储过程和函数
22.1.2 PL／SQL Server Pages
22.1.3 为XML启用PL／SQL Web应用程序
22.2 设置和检验PL／SQL服务器页
22.2.1 安装Oracle HTTP Server
22.2.2 创建一个PSP文件
22.2.3 将PSP文件导入到数据库
22.2.4 设置Oracle HTTP Server
22.2.5 从浏览器中调用PSP
22.3 PL／SQL Web应用程序的参数传递
22.3.1 从HTML表单中传递列表框或微调框参数
22.3.2 从HTML表单中传递单选按钮或复选框参数
22.3.3 从HTML表单传递输入域参数
22.3.4 从HTML表单中传递隐藏参数的值
22.3.5 提交一张完整的HTML表单
22.3.6 从HTML表单中处理丢失的输入
22.3.7 在网页之间维护状态信息
22.4 在PL／SQL存储过程中执行网络操作
22.4.1 从PL／SQL中发送邮件
22.4.2 从PL／SQL中得到一个主机名或地址
22.4.3 在PL／SQL中操作TCP／IP连接
22.4.4 从PL／SQL中检索一个HTTP URL的内容
22.4.5 操作表格、图像、Cookies和CGI变量
22.5 PL／SQL Server Pages
22.5.1 选择一个软件配置
22.5.2 为PL／SQL服务器页编写代码和内容
22.5.3 把PL／SQL服务器页装载到数据库存储过程
22.6 PL／SQL Server Pages实例
22.6.1 一次性显示表的内容
22.6.2 使用循环打印表的内容
22.6.3 用户选择
22.6.4 调用PL／SQL服务器页的HTML表单
22.6.5 在PSP文件中包含JavaScript
22.6.6 调试PL／SQL Server Pages
22.6.7 将PSP应用程序加入产品
22.7 小结
22.8 练习
第23章调整PL／SQL应用程序
23.1 PL／SQL性能问题的原因
23.2 识别PL／SQL性能问题
23.2.1 剖析API：DBMS_PROFILER包
23.2.2 跟踪API：DBMS_TRACE包
23.3 性能调整的PL／SQL特征
23.3.1 通过本机动态SQL改进PL／SQL性能
23.3.2 通过批联编提高PL／SQL性能
23.3.3 使用NOCOPY编译器提示来提高PL／SQL性能
23.3.4 使用RETURNING子句提高PL／SQL性能
23.3.5 使用外部程序提高PL／SQL性能
23.3.6 使用对象类型和集合来提高PL／SQL性能
23.3.7 编译PL／SQL代码以便于本地执行
23.4 小结
附录一 PL／SQL保留字
附录二部分练习答案
附录三部分表结构
附录四 SQL*Plus的使用
F4.1 启动SQL*Plus
F4.2 输入和执行命令
F4.3 编辑SQL命令
F4.4 创建和修改命令文件
F4.5 环境变量的设置和保存
F4.6 编写交互命令
F4.7 格式化查询结果

《Oracle9i PL/SQL从入门到精通》(绝版清晰PDG)

2008-01-03 15:53:47

【下载说明】
这里提供给大家的是《Oracle9i PL/SQL从入门到精通》一书的清晰PDG格式电子书下载。此书实例丰富，讲解详细，是掌握Oracle PL/SQL语言的极合适读物。

【内容提要】
Oracle9i是Oracle公司于2001年推出的最新版本的大型关系型数据库管理系统,它加强了用于电子商务环境的一系列特定功能,并提供了更好的可用性、可伸缩性、安全性、可管理性的开发平台。
全书包括23章，由浅入深地介绍了PL/SQL编程及其技巧。本书在向读者介绍基本PL/SQL的同时，还融合了很多Oracle9i中才有的PL/SQL新特性。本书内容划分为三大部分，首先是基础知识，介绍了PL/SQL简介、PL/SQL基础、控制结构、SQL基本命令、Oracle内置函数、自创建过程和函数、包和异常处理等内容；第二部分为应用开发，介绍了游标技术、触发器、集合、对象、本机动态SQL以及文件读写；最后一部分为高级部分介绍了会话间通信、Oracle高级队列、作业管理、大型对象、开发Web程序以及性能优化等PL/SQL高级技术。

【目录信息】
前言
第1章 PL／SQL简介
1.1 什么是PL／SQL
1.2 PL／SQL功能特性
1.2.1 块结构
1.2.2 变量和类型
1.2.3 程序控制结构
1.2.4 游标
1.2.5 过程和函数
1.2.6 包
1.2.7 动态SQL
1.2.8 对象类型
1.2.9 集合
1.2.10 内置包
1.3 Oracle 9i的 PL／SQL新特性
1.4 使用SQL*Plus
1.5 使用SQL*Plus Worksheet
1.6 小结
1.7 练习
第2章 PL／SQL基础
2.1 PL／SQL程序结构
2.1.1 PL／SQL块的类型
2.1.2 PL／SQL块的结构
2.1.3 词法单位
2.2 变量声明
作用域和可见性
2.3 PL／SQL变量类型
2.3.1 数字型
2.3.2 字符型
2.3.3 国际化字符类型
2.3.4 LOB（大型对象）类型
2.3.5 布尔（BOOLEAN）类型
2.3.6 日期和时间间隔（Datetime和Interval）类型
2.3.7 复合类型
2.3.8 引用类型
2.3.9 用户自定义类型
2.4 数据类型转换
2.4.1 显式转换（Explicit Conversion）
2.4.2 隐式转换（Implicit Conversion）
2.4.3 隐式转换和显式转换的比较
2.5 PL／SQL表达式
2.5.1 运算符的优先级
2.5.2 字符表达式
2.5.3 布尔表达式
2.5.4 CASE表达式
2.5.5 在比较和条件语句中处理NULL值
2.6 PL／SQL运算符
2.6.1 算术运算符
2.6.2 逻辑运算符
2.6.3 比较运算符
2.6.4 字符串运算符
2.6.5 用户自定义运算符
2.7 小结
2.8 练习
第3章表和记录
3.1 表
3.2 记录
3.2.1 记录的定义
3.2.2 记录赋值
3.3 ％TYPE和％ROWTYPE
3.3.1 使用％TYPE类型
3.3.2 使用％ROWTYPE类型
3.4 伪列
3.4.1 CURRVAL和NEXTVAL伪列
3.4.2 ROWID伪列
3.4.3 ROWNUM伪列
3.5 小结
3.6 练习
第4章 PL／SQL控制结构
4.1 条件控制
4.1.1 IF－THEN语旬
4.1.2 IF－THEN－ELSE语句
4.1.3 IF－THEN－ELSIF语句
4.1.4 CASE语句
4.1.5 搜索CASE语句
4.1.6 条件语句使用指导
4.2 循环结构
4.2.1 LOOP循环
4.2.2 WHILE－LOOP循环
4.2.3 FOR循环
4.2.4 循环语句使用指导
4.3 顺序结构
4.3.1 GOTO语句
4.3.2 NULL语句
4.4 小结
4.5 练习
第5章 SQL基本命令
5.1 SQL基本命令分类
5.2 数据定义语言（DDL）
5.3 数据操纵语言（DML）
5.3.1 INSERT语句
5.3.2 SELECT语句
5.3.3 UPDATE语句
5.3.4 DELETE语句
5.3.5 LOCK TABLE命令
5.4 事务控制命令
5.4.1 SET TRANSACTION
5.4.2 COMMIT与ROLLBACK
5.4.3 SAVE POINT
5.5 会话控制命令
5.5.1 ALTER SESSION命令
5.5.2 SET ROLE命令
5.6 系统控制命令
5.7 小结
5.8 练习
第6章 Oracle内置SQL函数
6.1 错误报告（Error Reporing）函数
6.2 数值（Number）函数
6.2.1 BITAND
6.2.2 CEIL
6.2.3 FLOOR
6.2.4 SIGN
6.2.5 ROUND
6.2.6 TRUNC
6.3 字符（Character）函数
6.3.1 CONCAT
6.3.2 INSTR
6.3.3 LPAD
6.3.4 LTRIM
6.3.5 NLS_INITCAP
6.3.6 NLS_LOWER
6.3.7 NLS_UPPER
6.3.8 NLSSORT
6.3.9 REPLACE
6.3.10 SOUNDEX
6.3.11 SUBSTR
6.3.12 TRANSLATE
6.3.13 TRIM
6.4 转换（Conversion）函数
6.4.1 CONVERT
6.4.2 TO_CHAR
6.4.3 TO_CLOB
6.4.4 TO_DATE
6.4.STO_MULTI_BYTE
6.4.6 TO_SINGLE_BYTE
6.4.7 TO_ NUMBER
6.5 日期（Date）函数
6.5.1 SYSDATE函数
6.5.2 ADD_MONTHS函数
6.5.3 CURRENT_DATE函数
6.5.4 CURRENT_TIMESTAMP函数
6.5.5 DBTIMEZONE函数
6.5.6 EXTRACT函数
6.5.7 FROM_TZ函数
6.5.8 LOCALTIMESTAMP函数
6.5.9 MONTHS_BETWEEN函数
6.5.10 NEW_TIME函数
6.5.11 NEXT_DAY函数
6.5.12 NUMTODSINTERVAL函数
6.5.13 NUMTOYMINTERVAL函数
6.5.14 ROUND函数
6.5.15 SESSIONTIMEZONE函数
6.5.16 SYSTIMESTAMP函数
6.5.17 TO_DSINTERVAL函数
6.5.18 TO_TIMESTAMP函数
6.5.19 TO_TIMESTAMP_TZ函数
6.5.20 TO_YMINTERVAL函数
6.5.21 TZ_OFFSET函数
6.5.22 TRUNC函数
6.6 分组（Group）函数
6.6.1 STDDEV函数
6.6.2 VARIANCE函数
6.7 杂项（Misc）函数
6.7.1 DECODE函数
6.7.2 DUMP函数
6.7.3 GREATEST函数
6.7.4 LEAST函数
6.7.5 NVL函数
6.8 小结
6.9 练习
第7章过程与函数
7.1 使用过程
7.1.1 创建过程
7.1.2 调用过程
7.1.3 重新编译过程
7.1.4 删除过程
7.2 使用函数
7.2.1 函数的定义
7.2.2 RETURN语句
7.2.3 调用函数
7.2.4 删除函数
7.3 子程序
7.3.1 内置子程序
7.3.2 本地子程序
7.4 递归
7.5 小结
7.6 练习
第8章包
8.1 包的概念
8.2 包的规范与创建
8.2.1 使用包的优势
8.2.2 理解包规范
8.2.3 理解包体
8.3 包的调用
8.4 包的重新编译和重载
8.4.1 包的重新编译
8.4.2 包的重载
8.5 小结
8.6 练习
第9章异常处理
9.1 什么是异常
9.2 PL／SQL预定义异常
9.3 PL／SQL的异常处理结构
9.3.1 异常的触发
9.3.2 异常的传播
9.4 自定义异常
9.4.1 声明异常
9.4.2 使用编译指令EXCEPTION_INIT
9.4.3 使用RAISE_APPLICATION_ERROR
9.4.4 使用错误函数SQLCODE和SQLERRM
9.5 小结
9.6 练习
第10章游标
10.1 什么是游标
10.2 显式游标
10.2.1 声明游标
10.2.2 打开游标（OPEN CURSOR）
10.2.3 提取游标（FETCH CURSOR）
10.2.4 关闭游标（CLOSE CURSOR）
10.2.5 显式游标的属性
10.2.6 在游标中使用子查询
10.2.7 在包中使用游标
10.3 隐式游标
10.4 游标提取循环
10.4.1 基本循环（LOOP…END LOOP）
10.4.2 WHILE循环
10.4.3 FOR循环（CURSOR FOR LOOP）
10.4.4 SELECT FOR UPDATE游标
10.5 游标变量
10.5.1 声明游标变量
10.5.2 控制游标变量
10.5.3 使用游标变量的限制
10.6 小结
10.7 练习
第11章触发器
11.1 触发器
11.2 DML触发器
11.2.1 创建DML触发器
11.2.2 访问行触发器中的列值
11.2.3 条件谓词
11.3 使用DML触发器
11.3.1 维护数据完整性
11.3.2 维护修改的历史日志
11.4 系统触发器
11.4.1 创建系统触发器
11.4.2 事件属性
11.4.3 系统触发器的例子
11.5 替代触发器
11.5.1 替代触发器的创建
11.5.2 替代触发器的编写
11.5.3 视图所包括的嵌套表上的列的触发器
11.6 触发器的例外
11.6.1 在触发器体的错误条件和例外
11.6.2 触发器和处理远程的例外
11.7 小结
11.8 练习
第12章事务管理和锁定
12.1 事务管理
12.1.1 COMMIT（提交）
12.1.2 ROLLBACK（回滚）
12.1.3 SAVEPOINT（保存点）
12.1.4 SET TRANSACTION
12.1.5 分布式事务的管理
12.1.6 RELEASE
12.2 锁定
12.2.1 表锁定
12.2.2 锁定记录
12.2.3 显式的锁定
12.2.4 其他的锁定
12.2.5 DBMS_LOCK包
12.3 小结
12.4 练习
第13章集合
13.1 集合概述
13.2 索引表
13.2.1 定义索引表
13.2.2 向索引表中插入数据
13.2.3 引用索引表的值
13.3 嵌套表
13.3.1 声明嵌套表
13.3.2 嵌套表的初始化和赋值
13.3.3 数据库中的嵌套表
13.4 变长数组
13.4.1 定义变长数组
13.4.2 初始化变长数组
13.4.3 数据库中的数组
13.5 使用集合方法
13.5.1 EXISTS方法
13.5.2 COUNT方法
13.5.3 LIMIT方法
13.5.4 FIRST和LAST方法
13.5.5 PRIOR和NEXT方法
13.5.6 EXTED方法
13.5.7 DELETE和TRIM方法
13.5.8 把方法用于集合参数
13.6 集合的异常处理
13.7 批联编
13.7.1 使用FORALL语句
13.7.2 使用BULK COLLECT
13.8 小结
13.9 练习
第14章 PL／SQL对象类型
14.1 面向对象的基本概念
14.1.1 对象（Object）
14.1.2 类（Class）
14.1.3 继承（Inheritance）
14.1.4 多态性
14.2 对象类型
14.2.1 为什么使用对象
14.2.2 对象类型的结构
14.2.3 对象类型的组成
14.3 定义对象类型
14.3.1 对象类型的定义
14.3.2 SELF参数
14.3.3 PL／SQL的继承
14.3.4 更改和删除对象类型
14.4 声明并初始化对象
14.4.1 声明对象
14.4.2 构造函数与初始化对象
14.5 对象的使用
14.5.1 存取属性
14.5.2 调用构造函数
14.5.3 调用方法
14.6 按列存储对象
14.7 对象表
14.7.1 创建对象表
14.7.2 向对象表中添加对象
14.7.3 检索对象表中的对象
14.7.4 更新对象表
14.7.5 删除对象表的对象
14.8 共享对象
14.8.1 引用
14.8.2 REF和DEREF函数
14.8.3 前期类型定义
14.9 比较对象
14.9.1 MAP方法
14.9.2 ORDER方法
14.9.3 指导要点
14.10 小结
14.11 练习
第15章跟踪和调试
15.1 调试语法错误
15.2 调试逻辑错误
15.2.1 逻辑错误例子
15.2.2 逻辑错误解决
15.3 使用工具调试程序
15.3.1 在程序中插入调试用表
15.3.2 DBMS_OUTPUT包
15.4 程序的规划与代码编写
15.4.1 程序结构的规划
15.4.2 编制代码
15.4.3 格式化代码
15.5 小结
15.6 练习
第16章本机动态SQL
16.1 什么是动态SQL
16.2 动态SQL的两种方法
16.3 使用EXECUTE IMMEDIATE语句
16.3.1 执行DDL
16.3.2 执行PL／SQL块
16.3.3 绑定变量
16.4 使用OPEN－FOR、FETCH和CLOSE语句
16.5 使用批动态SQL
16.5.1 批EXECUTE IMMEDIATE
16.5.2 批FETCH
16.5.3 批FORALL
16.6 动态SQL的技巧
16.6.1 改进性能
16.6.2 使用重复的占位符
16.6.3 使用游标属性
16.6.4 传递Null参数
16.6.5 远程操作
16.6.6 使用调用者特权
16.6.7 避免死锁
16.7 小结
16.8 练习
第17章输入与输出
17.1 DBMS_OUTPUT包
17.1.1 使用DBMS_OUTPUT包
17.1.2 启用DBMS_OUTPUT包
17.1.3 关闭DBMS_OUTPUT包
17.1.4 将数据写到缓冲区
17.1.5 从缓冲区中读取数据
17.1.6 应用举例
17.2 UTL_FILE包
17.2.1 安全性
17.2.2 使用UTL_FILE包函数与文件I／O步骤
17.2.3 UTL_FILE引发的异常
17.2.4 文件的打开与关闭
17.2.5 文件输出
17.2.6 文件输入
17.3 小结
17.4 练习
第18章会话间通信
18.1 DBMS_SESSION
18.1.1 SET_IDENTIFIER
18.1.2 SET_CONTEXT
18.1.3 CLEAR_CONTEXT
18.1.4 CLEAR_IDENTIFIER
18.1.5 SET_ROLE
18.1.6 SET_SQL_TRACE
18.1.7 SET_NLS
18.1.8 CLOSE_DATABASE_LINK
18.1.9 RESET_PACKAGE
18.1.10 UNIQUE_SESSION_ID函数
18.1.11 IS_ROLE_ENABLED函数
18.1.12 IS_SESSION_ALIVE函数
18.1.13 SET_CLOSE_CACHED_OPEN_CURSORS
18.1.14 FREE_UNUSED_USER_MEMORY
18.1.15 LIST_CONTEXT
18.1.16 SWITCH_CURRENT_CONSUMER_GROUP
18.2 DBMS_ALERT
18.2.1 包DBMS_ALERT中常量的定义
18.2.2 常见错误
18.2.3 报警使用机制
18.2.4 检查报警
18.2.5 DBMS_ALERT子程序的概述
18.3 DBMS_PIPE
18.3.1 公有管道和私有管道
18.3.2 DBMS_PIPE子程序的概述
18.4 小结
18.5 练习
第19章高级队列
19.1 高级队列简介
19.1.1 异步消息通知
19.1.2 监听功能
19.1.3 传播特征
19.1.4 队列监视
19.2 队列使用
19.2.1 为负载定义一个类型
19.2.2 CREATE_QUEUE_TABLE
19.2.3 ALTER_QUEUE_TABLE
19.2.4 DROP_QUEUE_TABLE
19.2.5 CREATE_QUEUE
19.2.6 CREATE_NP_QUEUE
19.2.7 ALTER_QUEUE
19.2.8 DROP_QUEUE
19.2.9 START_QUEUE
19.2.10 STOP_QUEUE
19.2.11 ENQUEUE
19.2.12 DEQUEUE
19.2.13 Message Properties
19.2.14 记录ENQUEUE_OPTIONS_T
19.2.15 AQ＄_AGENT对象类型
19.2.16 AQ＄_RECIPIENT_LIST_T对象类型
19.2.17 Dequeue Options Type
19.3 其他AQ过程
19.3.1 GRANT_SYSTEM_PRIVILEGE
19.3.2 REVOKE_SYSTEM_PRIVILEGE
19.3.3 GRANT_QUEUE_PRIVILEGE
19.3.4 REVOKE_QUEUE_PRIVILEGE
19.4 AQ中级知识
19.4.1 订阅者列表和接收者列表
19.4.2 订阅者列表
19.4.3 接收者列表
19.4.4 AQ执行发布/订阅
19.4.5 AQ Recipient List Type（接收者列表数据类型）
19.4.6 AQ Agent List Type（代理列表类型）
19.4.7 AQ Subscriber List Type（订阅者列表类型）
19.4.8 AQ Registration Info Type（AQ注册信息类型）
19.4.9 AQ Registration Info List Type
19.4.10 LISTEN过程
19.4.11 REGISTER过程
19.4.12 UNREGISTER过程
19.4.13 ADD_SUBSCRIBER过程
19.4.14 ALTER_SUBSCRIBER过程
19.4.15 REMOVE_SUBSCRIBER过程
19.4.16 SCHEDULE_PROPAGATION过程
19.4.17 UNSCHEDULE_PROPAGATION过程
19.4.18 VERIFY_QUEUE_TYPES过程
19.4.19 ALTER_PROPAGATION_SCHEDULE过程
19.4.20 ENABLE_PROPAGATION_SCHEDULE过程
19.4.21 DISABLE_PROPAGATION_SCHEDULE过程
19.5 AQ实例
19.5.1 创建队列表和队列
19.5.2 消息入队出队
19.5.3 消息传播
19.5.4 删除AQ对象
19.6 小结
19.7 练习
第20章数据库作业管理
20.1 如何运行作业
20.2 管理作业队列
20.2.1 DBMS_JOB包
20.2.2 作业环境（Job Environment）
20.2.3 作业的导入导出（Import/Export）
20.3 小结
20.4 练习
第21章大型对象
21.1 大型对象类型概述
21.1.1 什么是大型对象
21.1.2 大型对象数据类型
21.1.3 可变宽度（Varying－Width）字符数据
21.1.4 大型对象值和定位器
21.1.5 创建包含大型对象的表
21.2 Oracle 9i中大型对象的新特征
21.3 用PL／SQL的DBMS_上OB包
21.3.1 DBMS_LOB包函数／过程介绍
21.3.2 DBMS_LOB包的大型对象定位器
21.3.3 DBMS_LOB包的数据类型常数及异常
21.3.4 DBMS_LOB包的规则和限制
21.4 使用外部大型对象BFILE
21.4.1 创建目录对象
21.4.2 打开BFILE
21.4.3 函数FILEISOPEN
21.4.4 函数FILEEXISTS
21.4.5 关闭文件的过程
21.4.6 获得文件信息
21.4.7 读文件操作
21.4.8 比较两个文件内容
21.4.9 INSTR函数
21.4.10 SUBSTR函数
21.5 使用外部大型对象BFILE的范例
21.6 使用内部大型对象
21.6.1 APPEND过程
21.6.2 COMPARE函数
21.6.3 COPY过程
21.6.4 EMPTY_BLOB和EMPTY_CLOB函数
21.6.5 ERASE过程
21.6.6 GETLENGTH函数
21.6.7 INSTR函数
21.6.8 READ过程
21.6.9 SUBSTR函数
21.6.10 TRIM过程
21.6 11 WRITE过程
21.6.12 WRITEAPPEND过程
21.7 使用内部大型对象的范例
21.7.1 向内部LOB拷贝数据
21.7.2 向内部LOB中添加数据
21.7.3 分析内部LOB内容
21.7.4 编辑内部LOB对象
21.8 临时大型对象
21.8.1 临时大型对象概述
21.8.2 临时大型对象的使用
21.9 LONG与LOB数据类型
21.9.1 LONG与LOB数据类型的比较
21.9.2 LONG与LOB数据类型的转换
21.10 小结
21.11 练习
第22章开发Web应用程序
22.1 PL／SQL Web应用程序概念
22.1.1 使用PL／SQL存储过程和函数
22.1.2 PL／SQL Server Pages
22.1.3 为XML启用PL／SQL Web应用程序
22.2 设置和检验PL／SQL服务器页
22.2.1 安装Oracle HTTP Server
22.2.2 创建一个PSP文件
22.2.3 将PSP文件导入到数据库
22.2.4 设置Oracle HTTP Server
22.2.5 从浏览器中调用PSP
22.3 PL／SQL Web应用程序的参数传递
22.3.1 从HTML表单中传递列表框或微调框参数
22.3.2 从HTML表单中传递单选按钮或复选框参数
22.3.3 从HTML表单传递输入域参数
22.3.4 从HTML表单中传递隐藏参数的值
22.3.5 提交一张完整的HTML表单
22.3.6 从HTML表单中处理丢失的输入
22.3.7 在网页之间维护状态信息
22.4 在PL／SQL存储过程中执行网络操作
22.4.1 从PL／SQL中发送邮件
22.4.2 从PL／SQL中得到一个主机名或地址
22.4.3 在PL／SQL中操作TCP／IP连接
22.4.4 从PL／SQL中检索一个HTTP URL的内容
22.4.5 操作表格、图像、Cookies和CGI变量
22.5 PL／SQL Server Pages
22.5.1 选择一个软件配置
22.5.2 为PL／SQL服务器页编写代码和内容
22.5.3 把PL／SQL服务器页装载到数据库存储过程
22.6 PL／SQL Server Pages实例
22.6.1 一次性显示表的内容
22.6.2 使用循环打印表的内容
22.6.3 用户选择
22.6.4 调用PL／SQL服务器页的HTML表单
22.6.5 在PSP文件中包含JavaScript
22.6.6 调试PL／SQL Server Pages
22.6.7 将PSP应用程序加入产品
22.7 小结
22.8 练习
第23章调整PL／SQL应用程序
23.1 PL／SQL性能问题的原因
23.2 识别PL／SQL性能问题
23.2.1 剖析API：DBMS_PROFILER包
23.2.2 跟踪API：DBMS_TRACE包
23.3 性能调整的PL／SQL特征
23.3.1 通过本机动态SQL改进PL／SQL性能
23.3.2 通过批联编提高PL／SQL性能
23.3.3 使用NOCOPY编译器提示来提高PL／SQL性能
23.3.4 使用RETURNING子句提高PL／SQL性能
23.3.5 使用外部程序提高PL／SQL性能
23.3.6 使用对象类型和集合来提高PL／SQL性能
23.3.7 编译PL／SQL代码以便于本地执行
23.4 小结
附录一 PL／SQL保留字
附录二部分练习答案
附录三部分表结构
附录四 SQL*Plus的使用
F4.1 启动SQL*Plus
F4.2 输入和执行命令
F4.3 编辑SQL命令
F4.4 创建和修改命令文件
F4.5 环境变量的设置和保存
F4.6 编写交互命令
F4.7 格式化查询结果

Oracle Database 11g New Features

2008-01-02 22:19:26

Your Must-Have Guide to Everything New in Oracle Database 11g.
Realize the full potential of Oracle Database 11g with help from the experts. Written by Robert G. Freeman, and with insightful commentary throughout from Arup Nanda, this Oracle Press guide offers full details on the architectural changes, database administration upgrades, availability and recovery revisions, security enhancements, and programming innovations. Every new and updated feature is covered and presented with screenshots, code samples, tables, and charts. Find out how to take full advantage of all the new and improved capabilities of Oracle Database 11g, including:
*New Oracle Automatic Storage Management features, such as Fast Disk Resync, Compatibility Attributes, Preferred Mirror Read, and Rolling Upgrade components
*Improved Automated Memory Management capabilities
*New database design features, such as virtual columns, tablespace encryption, and true table-level data compression
*New Database Advisors for data recovery and repair, partitioning, and streams performance
*New tuning features, such as Automatic SQL Tuning and SQL Performance Analyzer
*Enhancements to Oracle RMAN, including active database duplication and UNDO backup optimization
*Improved auditing and security capabilities
*Advanced BI, data warehousing, and partitioning features
*New SQL and PL/SQL enhancements

《Oracle数据库攻防之道》（The Oracle Hacker's Handbook: Hacking and Defending Oracle）英文版

2008-01-01 21:11:43

【下载说明】
这里提供给大家的是《The Oracle Hacker's Handbook: Hacking and Defending Oracle》（Oracle数据库攻防之道）一书的英文版CHM格式电子书下载。书虽不厚，值得你钻研；本档案随不大，但绝对完整。

【作者简介】
David Litchfield是NGSSoftware公司的创始人和首席科学家，该公司致力于为英国提供安全解决方案。Litchfield被认为是世界上最权威的Oracle数据库安全专家，他发现了Oracle 9i Database Server中的一个重要的安全漏洞，并有力地反驳了Oracle“无懈可击”的市场宣传，从而赢得了极高的声誉。Litchfield还是NGSSQuirreL(一种功能强大的数据库服务器漏洞检测及风险评估工具)的设计者。另外，他还是一位出色的演讲者，经常在政府安全机构和国际会议上演讲，也经常在Blackhat Security Briefings、Micro..

【内容提要】
虽然Oracle不断改进自己产品的安全特征，但它仍然还有一段很长的路要走。本书作者David Litchfield将自己多年积累的有关数据库安全方面的丰富经验与读者分享，教会读者如何评估和防护自己的Oracle数据库。与《数据库黑客大曝光——数据库服务器防护术》一书(已由清华大学出版社引进并出版)一样，本书也深入探讨了黑客在入侵和威胁Oracle系统时可能用到的各种技术和工具，告诉读者如何找到系统的弱点并保护它。一旦拥有了这些知识，数据库的安全性就有了保证。

【前言摘要】
It's terribly important that Oracle get security right, and so far their record has been poor. The Oracle RDBMS has had more critical security vulnerabilities than any other database server product. By critical, I mean those flaws that can be exploited by a remote attacker with no user ID and password and which gives them full control over the database server. To put these critical security vulnerabilities in context, IBM's DB2 has had 1; Informix has had 2; and Microsoft's SQL Server has had 2. Oracle has had 9. That's more than the other database servers put together. In terms of flaws that require a user ID and password but yield full control when exploited, again Oracle outstrips the rest by far. These facts stand in stark contrast to Oracle's marketing campaigns claiming that their product is "unbreakable." When Oracle executives say, "We have the security problem solved. That's what we're good at … ," it makes you wonder what they're talking about. So far the problem is not solved, and complacency should have no home in an organization that develops software that is installed in most governments' networks. This is why it is absolutely critical for Oracle to get it right-national security is at stake.

【目录信息】
Introduction
Chapter 1 - Overview of the Oracle RDBMS
Chapter 2 - The Oracle Network Architecture
Chapter 3 - Attacking the TNS Listener and Dispatchers
Chapter 4 - Attacking the Authentication Process
Chapter 5 - Oracle and PL/SQL
Chapter 6 - Triggers
Chapter 7 - Indirect Privilege Escalation
Chapter 8 - Defeating Virtual Private Databases
Chapter 9 - Attacking Oracle PL/SQL Web Applications
Chapter 10 - Running Operating System Commands
Chapter 11 - Accessing the File System
Chapter 12 - Accessing the Network
Appendix A - Default Usernames and Passwords
Index
List of Figures

PL SQL培训教程

2007-12-21 11:12:59

目录............................................................................................................................................................................................................... 2
UNIT1 SQL、PL/SQL 概要............................................................................................................................................................... 1
单元培训目标................................................................................................................................................................................ 1
LESSON 1 SQL、SQL*Plus 和PL/SQL基本概念 ................................ ................................ ................................ ............. 1
UNIT2 数据查询.................................................................................................................................................................................. 3
单元培训目标................................................................................................................................................................................ 3
LESSON 1简单的数据查询....................................................................................................................................................... 3
LESSON 2 SQL*Plus 的使用..................................................................................................................................................... 5
LESSON 3 单行函数的使用...................................................................................................................................................... 6
LESSON 3多表数据查询........................................................................................................................................................... 7
LESSON 4组函数 ................................ ................................ ................................ ................................ ................................ ........ 8
LESSON 5 子查询................................ ................................ ................................ ................................ ................................ ........ 9
UNIT3数据库....................................................................................................................................................................................... 10
单元培训目标.............................................................................................................................................................................. 10
LESSON 1系统开发周期和数据关联................................................................................................................................... 11
LESSON ２创建表、序列、视图和索引............................................................................................................................. 12
LESSON 3Oracle 数据字典................................ ................................ ................................ ................................ ...................... 15
LESSON 4用户访问控制......................................................................................................................................................... 15
UNIT4 PL/SQL................................ ................................ ................................ ................................ ................................ ...................... 18
单元培训目标.............................................................................................................................................................................. 18
LESSON 1简单 PL/SQL................................ ................................ ................................ ................................ ........................... 18
LESSON ２数据获取和游标 ................................................................................................................................................... 24
LESSON ３PL/SQL控制流..................................................................................................................................................... 25
LESSON ４出错处理................................ ................................ ................................ ................................ ................................ . 25
附录 A: ................................................................................................................................................................................................... 26
数据结构： .................................................................................................................................................................................. 26
描述：................................ ................................ ................................ ................................ ................................ ........................... 26

Oracle Reports培训教程

2007-12-21 11:09:25

文档控制...................................ii
综述.............................4
Oracle Reports概述....................................4
Oracle Reports 的版本.......................4
Oracle Reports 的安装.......................4
建立并运行一个简单的报表 ..........................4
建立报表.................................................4
编译运行报表...................... ...4
习题......................................4
数据模型（Date Model）............................4
功能及构成.............................................4
数据模型编辑器.....................................4
查询..........................................................4
组.......................................................4
列.............................................4
数据连接.................................4
参数......................................4
布局（Layout）..............................4
布局功能.........................................4
布局模型编辑器.......................................4
报表区域..........................................4
基本布局对象................................ ...4
几种缺省的报表布局风格.............................. .............4
参数表格（Parameter Form）.................................4
建立用户自定义的参数表格 .........................4
报表触发器（Report Triggers）........................4
触发器的触发时机及用途.................4
习题.................................................4
程序单元（Program Units）....................4
附加的程序库（Attached Libraries）.............. ........................4
建立 PL/SQL程序库..........................4
连接 PL/SQL程序库...........................4
习题......................................................4
矩阵式报表.................................................4
建立矩阵式报表的需求 ....................................4
单查询矩阵式报表................................4

Oracle Reports培训教程 20.doc
MD060采购
iv
hand仅限于内部使用
多查询矩阵式报表.......................................................4
Reports在Applications 下的安装................................................4
编制Report .........................................4
在Application中注册Reports....................................4
将Reports运行权限赋给相应的职责...................................4

Oracle Automatic Storage Management: Under-the-Hood & Practical Deployment Guide

2007-12-21 08:23:29

介绍来自：http://www.amazon.com/exec/obidos/tg/detail/-/0071496076/
--------------------------------

Book Description

Build and manage a scalable storage infrastructure with Oracle Automatic Storage Management

Streamline data management and provisioning using Oracle Automatic Storage Management (Oracle ASM) and the detailed information contained in this exclusive Oracle Press resource. Written by a team of database experts, Oracle Automatic Storage Management: Under-the-Hood & Practical Deployment Guide explains how to build and maintain a dynamic, highly available Oracle database storage environment. Inside, you'll learn how to configure storage for Oracle ASM, build disk groups, use data striping and mirroring, and optimize performance. You'll also learn how to ensure consistency across server and storage platforms, maximize data redundancy, and administer Oracle ASM from the command line.

Manage Oracle ASM Instances and configure Oracle RDBMS instances to leverage Oracle ASM
Define, discover, and manage disk storage under Oracle ASM
Create external, normal-redundancy, and high-redundancy disk groups
Add and remove Oracle ASM storage without affecting RDMS instance availability
Learn how Oracle ASM provides even I/O distribution
Work with Oracle ASM directories, files, templates, and aliases
Improve storage performance and integrity using the ASMLIB API
Simplify system administration with the Oracle ASM command line interface
Understand key internal Oracle ASM structures and algorithms

About the Author

Nitin Vengurlekar works at Oracle in the Real Application Cluster (RAC) engineering group, with specific emphasis on ASM. Nitin is a popular conference presenter on this topic.

Murali Vallath is an Oracle Certified Database Administrator and is president of the Oracle RAC Special Interest Group.

Rich Long is Director of Development for Automatic Storage Management at Oracle and has managed ASM development since the project’s inception.

---------------

Paperback: 340 pages
Publisher: McGraw-Hill Osborne Media; 1 edition (November 5, 2007)
Language: English

Pro Oracle Spatial for Oracle Database 11g

2007-12-19 10:13:04

Pro Oracle Spatial for Oracle Database 11g

Author: Ravikanth V. Kothuri, Albert Godfrind, Euro Beinat
Publisher: Apress
Number Of Pages: 824
Publication Date: 2007-10-29
ISBN-10 / ASIN: 1590598997
ISBN-13 / EAN: 9781590598993
Binding: Paperback

Pro Oracle Spatial for Oracle Database 11g shows how to take advantage of Oracle Database's built-in feature set for working with location-based data. A great deal of the information used in business today is associated with location in some way, and analysis of that data is becoming ever more important in today's mobile and highly connected world. In Pro Oracle Spatial for Oracle Database 11g, authors Ravi Kothuri and Albert Godfrind address

The special nature of spatial data and its role in professional and consumer applications
Issues in spatial data management such as modeling, storing, accessing, and analyzing spatial data
The Oracle Spatial solution and the integration of spatial data into enterprise databases
How spatial information is used to understand business and support decisions, to manage customer relations, and to better serve private and corporate users
When you read Pro Oracle Spatial for Oracle Database 11g, you're learning from the very best. Ravi Kothuri is a key member of Oracle's Spatial development team. Albert Godfrind consults widely with Oracle clients on the implementation of Oracle Spatial, develops training courses, and presents frequently at conferences. Together they have crafted a technically sound and authoritative fountain of information on working with spatial data in the Oracle database.

What you'll learn
Pro Oracle Spatial for Oracle Database 11g delivers in helping you fully understand Oracle's spatial data feature set. In reading the book, you'll learn

About new Oracle Spatial features in Oracle Database 11g, including support for the European Petroleum Standards Group (EPSG) data model, the ability to publish to Google Earth, integration with Google Maps, and much more
The use of Oracle's built-in SDO_GEOMETRY data type for storing location-based data
How to geocode your data, beginning with postal addresses and ending with SDO_GEOMETRY objects that enable future analysis as well as forming the foundation of working with spatial data within Oracle
How to create and display maps to help you visualize and analyze your geocoded data
About network modeling, which is useful in computing routes, travel distances, and proximity based upon travel time
How to optimize analysis of your spatial data by creating spatial indexes and custom operators
Who is this book for?
Pro Oracle Spatial for Oracle Database 11g is aimed at software developers who wish to develop applications using Oracle's extensive and strong support for working with spatial, or geocoded, data.

About the Apress Pro Series
The Apress Pro series books are practical, professional tutorials to keep you on and moving up the professional ladder.

You have gotten the job, now you need to hone your skills in these tough competitive times. The Apress Pro series expands your skills and expertise in exactly the areas you need. Master the content of a Pro book, and you will always be able to get the job done in a professional development project. Written by experts in their field, Pro series books from Apress give you the hard-won solutions to problems you will face in your professional programming career.

Related Titles from Apress
Expert Oracle Database Architecture: 91 and 10g Programming Techniques and Solutions
Mastering Oracle SQL and SQL*Plus

Summary: Must a read book
Rating: 5

I am currently working on system, the involves Oracle Spatial technology. This book was going to be me first step (almost) towards getting familliar with Spatial. I was little anxious about the level expected from the book's reader: "Intermediate-Advanced"; I haven't exactly felt like "advanced" in Oracle technology. It wasn't so bad; the book is really well written and I had no problems with understanding anything.

The book consists of six parts (including appendices). All the parts cover following subjects:
- Introduction to the technology. Technologies, to be exact; architectures of both, Spatial and Locator options are described -
differences between them.
- Basic concepts - basic know-how. The part, I needed the most met my expectations in 100%. It helped me to start coding really fast.
- Network analysis - more advanced subjects covered, the mostly ARE NOT available in Locator option (one I have access to); network analysis and routing engine, geometry engine. Also indexes and operators are described in one chapter of the book.
- Map Visualisation and creation - a lot of knowlege about MapBuilder, MapViewer and it's API - really helpful for anybody, who needs to visualize maps stored in Spatial.
- Sample applications and case studies - I always look for such chapter in every IT book I read. This is the place, where programmer might find a lot of answers to one's questions. There is also a chapter in this part, the belongs to the category "MUST read" - "Tips, common mistakes and common errors".

There is also sample code available for the readers - to be downloaded from the publisher's web page. It is really helpful to have it while reading the book. There is only one "but" - was, to be exact. About two weeks after the book had been published, the code wasn't available on the page. At least, I couldn't find it. Now it is possible to download it from here.

The book is really good - "must have" of every Oracle Spatial user. It might be helpful for the beginner and advanced developers as well. I would recommend it to everyone, who needs to get to know Oracle Spatial well. All the 756 pages (excluding index) are filled with reliable knowledge, especially that one of the authors - Ravi Kothuri is a member of Oralce spatial development team, where he works as software architect and team leader.

Effective Oracle Database 10g Security by Design

2007-12-18 15:44:54

Oracle security expert David Knox explains how to design and develop an integrated, secure Oracle environment. “In my experience in the security world, including 32 years at the Central Intelligence Agency, I’ve not found anyone with more experience in the theory and practice of protecting your data than David Knox.” --Dave Carey, former Executive Director of the CIA

From the Back Cover

Protect Your Mission-Critical Data with Tips and Tricks from an Oracle Security Insider

Oracle expert David Knox has written the most practical, up-to-date book on Oracle Database 10g security available. With an emphasis on real-world problems and detailed solutions, Effective Oracle Database 10g Security by Design provides all the information you need to develop and deploy secure database applications. The entire security cycle is covered--from identification and authentication to fine-grained access control and encryption to effective auditing techniques. The material is presented with comprehensive yet easy-to-understand examples that show how to use all the security technologies in a complementary way.

* Assess database vulnerabilities and develop effective security policies
* Preserve user identity with in-depth analyses of JDBC connection pools, proxy authentication, and client identifiers
* Manage database users from a central directory without sacrificing security
* Lock down database access using secure application roles
* Leverage application and database security within Oracle’s Identity Management infrastructure
* Validate user privileges by using simple views and scripts
* Protect individual data elements by using the new Oracle DBMS_CRYPTO package
* Exploit database views to provide row-level and column-level fine-grained access controls
* Enforce need-to-know access and data privacy with Virtual Private Database and Oracle Label Security
* Ensure user accountability with Oracle fine-grained Auditing

David Knox is the chief engineer for Oracle’s Information Assurance Center and is one of the premier educators worldwide on Oracle security. While at Oracle he has worked on wide-ranging security programs for various customers including the U.S. Department of Defense, intelligence agencies, financial services companies, and healthcare organizations.
Table of Contents

Foreword by Dave Carey, former Executive Director of the Central Intelligence Agency

Part I: Quick Start

Ch 1: Best Practices

Ch 2: Oracle Database Best Practices

Ch 3: Security for the Grid

Part II: Identification & Authentication

Ch 4: Understanding Identification and Authentication

Ch 5: Proxy Authentication

Ch 6: Enterprise Users & Client Identifiers

Ch 7: Reference Example

Part III: Authorizations

Ch 8: Demystifying Authorizations, Access Controls, and Roles

Ch 9: Roles Choices

Ch 10: Reference Example

Part IV: Fine Grained Access Controls

Ch 11: Row-level Security

Ch 12: Column-level Security

Ch 13: Database Encryption

Ch 14: Reference Example

Part V: Auditing

Ch 15: Standard Auditing

Ch 16: Fine-Grained Auditing

Ch 17: Other Options

Ch 18: Reference Example

Part VI: Added Security Measures

Ch 19: How to Secure PL/SQL

Ch 20: Tips and Tricks

中南大学---大型数据库技术课件

2007-12-16 15:14:25

大型数据库技术第01章——绪论
大型数据库技术第02章——oracle SQL讲稿
大型数据库技术第02章——oracle 创建
大型数据库技术第02章——oracle 结构
大型数据库技术第02章——oracle 启动
大型数据库技术第02章——Oracle
大型数据库技术第03章——SQL Server 2000
大型数据库技术第04章——数据库设计
大型数据库技术第05章——PowerBuilder介绍
大型数据库技术第06章——JDBC介绍1
大型数据库技术第06章——JDBC介绍
大型数据库技术第07章——SQLJ
大型数据库技术第07章——存储过程与触发器
大型数据库技术第08章——数据库安全完整性
大型数据库技术第10章——分布式数据库系统

====
注:
如下载的朋友请不要用做商业培训等,
====

Guerrilla Oracle: The Succinct Windows Perspective

2007-12-01 11:56:54

Are you frustrated by your attempts to learn Oracle or improve your Oracle skills because of the sheer amount of technical documentation you have to wade through? This concise tutorial walks you step-by-step through the process, showing you exactly what you need to know to install, create, and support a successful Oracle 8i or 9i environment with Web capabilities.

Guerrilla Oracle: The Succinct Windows Perspective presents clear explanations of database, SQL, and Oracle fundamentals. Using a real-world, large-scale example to demonstrate essential tasks, the book follows the Oracle DBMS life cycle from business idea to functioning database.

Guerrilla Oracle? gives you the foundation you need to build a functioning system and to begin exploring more complex technical topics. Along with a deeper understanding of the Oracle DBMS, you will learn the concrete skills, strategies, and techniques you need to make your database a reality.

You will learn how to:

Install and configure the Oracle Database server on a Windows server

Configure client PCs

Install and define the Oracle Database software

Create basic database security schemas and formalize backup plans

Design a database and normalize the data

Integrate a legacy system into the Oracle relational database model using SQL*Loader

Create the tables

Develop and modify Oracle Forms and Reports

Program in SQL, SQL*Plus, and PL/SQL

Perform major DBA responsibilities

Enable remote access

Prepare your database for Web access and e-commerce

Oracle DBA Automation Quick Reference

2007-12-01 11:09:37

The fast, practical Oracle 9i/10g automation reference for every DBA!

Automate Oracle—and save your time for more important tasks! This is the Oracle automation reference every working Oracle DBA needs...concise, straightforward, and incredibly easy to use. Discover proven solutions for automating installation, database creation, management, monitoring, tuning, backup/recovery, and more. Keep this book by your desk, near your server...wherever you need fast, reliable automation solutions right now!

Master scripting for both Oracle 9i and Oracle 10g!

Use Oracle Universal Installer to create response files for automating any installation

Use Oracle Network Configuration Assistant (NetCA) to configure network components during installation

Use Oracle Database Configuration Assistant (DBCA) to create and clone databases, and to reverse engineer them into templates and scripts

Manage files and tablespaces, tune memory, perform backup/recovery, schedule automated administration tasks, and more

Extend and customize any script to your own needs

Includes concise reference to Perl DBI and its Oracle-specific components—with real-world examples and syntax

Oracle PL/SQ by Example, Third Edition

2007-12-01 11:03:47

Start developing applications with Oracle PL/SQL--fast! This integrated book-and-Web learning solution teaches all the Oracle PL/SQL skills you need, hands on, through real-world labs, extensive examples, exercises, projects, and a complete Web-based training site. Oracle PL/SQL by Example, Third Edition covers Oracle 10g and all the fundamentals: Master PL/SQL syntax, iterative and conditional control, scoping, anchored datatypes, cursors, triggers, security, tables, procedures, functions, packages and Oracle-supplied packages--plus powerful new techniques for working with exceptions, cursors, collections, and records. Your free Web-based training module includes a Virtual Study Lounge where you can interact with other learners, work on new projects, and get updates!

Oracle9i DBA JumpStart

2007-12-01 10:54:07

Introduction
So, you want to be an Oracle database administrator (DBA), but you’re not sure what the job might be like? Well, this is a good place to start! This book is intended to bridge the gap for people who are technically oriented but are not quite ready for an Oracle Certified Associate or Oracle Certified Professional study guide. If you don’t have a lot of direct experience with databases, this book can get you up to speed on enough of the basics to feel comfortable going into Oracle’s official certification track.

What You Need
Oracle9i DBA JumpStart assumes some minimal level of expertise in using an operating system such as Windows or Unix in a graphical user interface (GUI) environment. Any experience with a personal database, such as Microsoft Access, is helpful but not required.

To follow along with the examples in the book, you will need an installation of the Oracle database software version 9.0 or 9.2, Standard or Enterprise Edition, including the sample schemas provided by Oracle in the installation package, preferably on a Microsoft Windows platform.

Oracle_数据库_计算机类_最新资料_得益网

Oracle.PL.SQL.Programming.4th

OCP Oracle Database 11g: New Features for Administrators Exam Guide

Oracle Regular Expressions

oracle 9i10g编程艺术

Troubleshooting Oracle Performance

PLSQLDev6.0用户指南

2 Day Developer Guide for Oracle 10g XE

Oracel 10g XE 2 Day DBA

Oracle9i for Windows NT 2000数据库系统培训教程高级篇(PDG)

Introduction to OracleSQL and PLSQL

OCA Oracle Application Server 10g Administration I Study Guide

Oracle Essentials Oracle Database 11g 4th Edition

Oracle数据库基础知识ISSUE1.0(课程资料推荐下载)

Oracle PL/SQL Best Practices, 2nd Edition (新版)

北大青鸟ORACLE教程

Auerbach.Publications.Oracle.11i.E-Business.Suite.From.The.Front.Lines.eBook-LiB

Oracle PL/SQL Language Pocket Reference, 4th Edition（新版）

Oracle Database 11g SQL

地理信息系统建库技术及其应用

Oracle Database 11g New Features

Oracle9i PL/SQL从入门到精通 pdf版本

《Oracle9i PL/SQL从入门到精通》(绝版 清晰PDG)

Oracle Database 11g New Features

《Oracle数据库攻防之道》（The Oracle Hacker's Handbook: Hacking and Defending Oracle） 英文版

PL SQL培训教程

Oracle Reports培训教程

Oracle Automatic Storage Management: Under-the-Hood & Practical Deployment Guide

Pro Oracle Spatial for Oracle Database 11g

Effective Oracle Database 10g Security by Design

中南大学---大型数据库技术课件

Guerrilla Oracle: The Succinct Windows Perspective

Oracle DBA Automation Quick Reference

Oracle PL/SQ by Example, Third Edition

Oracle9i DBA JumpStart

《Oracle9i PL/SQL从入门到精通》(绝版清晰PDG)

《Oracle数据库攻防之道》（The Oracle Hacker's Handbook: Hacking and Defending Oracle）英文版