Oracle套用开发 _生活百科

文章插图
Oracle套用开发【Oracle套用开发】《Oracle套用开发》是2013年电子工业出版社出版的图书，作者是青岛东合信息技术有限公司。
基本介绍作者：青岛东合信息技术有限公司
ISBN：9787121209093
页数：524
定价：69
出版社：电子工业出版社
出版时间：2013-7
装帧：平装
副标题：高等院校软体专业方向系列教材
内容介绍本书从资料库的基本概念出发，以Oracle 11g 资料库为背景详细地介绍了资料库的原理和资料库系统的开发技术。理论篇共分为11 章，分别介绍了关係型资料库的概念和理论、Oracle 资料库体系结构、SQL Developer 工具的使用、SQL 语句、函式、表、数据维护、视图、PL/SQL 语法、游标、函式异常、序列、触发器、数据恢复、并发控制以及资料库安全等内容。书中通过SQL Developer 和SQL *Plus 工具实现对Oracle的数据查询，并详细介绍如何通过SQL 语句实现表格、索引、约束、视图、存储过程、函式、触发器、序列以及PL/SQL 的编写。本书重点突出、偏重套用，结合理论篇的实例和实践篇对贯穿案例的讲解、剖析及实现，使读者能迅速理解并掌握知识，全面提高动手能力。本书适应面广，可作为本科计算机科学与技术、软体外包专业、高职高专计算机软体、计算机网路、计算机信息管理、电子商务和经济管理等专业的程式设计课程的教材。作品目录理论篇...............................................................................................................................1第1 章关係型资料库.........................................................................................................21.1 资料库概述.......................................................................................................................41.1.1 资料库基本概念..................................................................................................41.1.2 资料库发展史......................................................................................................61.1.3 资料库特徵..........................................................................................................91.1.4 常见资料库..........................................................................................................91.2 数据模型......................................................................................................................... 111.2.1 概念模型............................................................................................................ 111.2.2 逻辑数据模型....................................................................................................141.3 关係模型理论.................................................................................................................181.3.1 关係....................................................................................................................201.3.2 关係模式............................................................................................................231.3.3 关係的完整性....................................................................................................241.3.4 关係代数............................................................................................................261.4 规範化理论.....................................................................................................................341.4.1 规範化理论的提出............................................................................................341.4.2 函式依赖............................................................................................................371.4.3 函式依赖定义的码............................................................................................401.4.4 範式及各範式的关係........................................................................................411.4.5 多值依赖............................................................................................................501.4.6 规範化思想........................................................................................................511.5 资料库设计.....................................................................................................................521.5.1 资料库设计特点................................................................................................531.5.2 需求分析............................................................................................................551.5.3 数据流图和数据字典........................................................................................571.6 概念结构设计.................................................................................................................581.6.1 概念结构设计定义............................................................................................591.6.2 概念结构设计的方法和步骤............................................................................601.6.3 数据抽象............................................................................................................611.6.4 E-R 图的生成.....................................................................................................621.7 逻辑结构设计.................................................................................................................661.7.1 初始关係模式设计.............................................................................................661.7.2 数据模型最佳化的方法.........................................................................................681.7.3 模式评价与改进................................................................................................68小结....................................................................................................................70练习..................................................................................................................70第2 章 Oracle 资料库........................................................................................762.1 Oracle 资料库概述..........................................................................................................782.1.1 Oracle 资料库简介.............................................................................................782.1.2 Oracle 发展史.....................................................................................................792.1.3 Oracle 资料库的套用结构.................................................................................812.2 Oracle 体系结构..............................................................................................................832.3 Oracle 资料库存储结构..................................................................................................842.3.1 物理存储结构....................................................................................................852.3.2 逻辑存储结构....................................................................................................882.4 Oracle 资料库实例..........................................................................................................902.4.1 Oracle 实例概述.................................................................................................902.4.2 SGA ....................................................................................................................922.4.3 PGA ....................................................................................................................952.4.4 后台进程............................................................................................................97小结..........................................................................................................101练习.....................................................................................................................102第3 章 SQL Developer 开发工具..............................................................................1033.1 SQL Developer 概述....................................................................................................1053.1.1 SQL Developer 简介........................................................................................1053.1.2 SQL Developer 下载........................................................................................1053.1.3 创建资料库连线..............................................................................................1073.2 SQL Developer 基本操作.............................................................................................1093.2.1 数据操作..........................................................................................................1103.2.2 表的创建、修改..............................................................................................1123.3 开发与调试...................................................................................................................1163.3.1 创建存储过程..................................................................................................1163.3.2 运行存储过程..................................................................................................1193.3.3 调试存储过程..................................................................................................1203.4 导入与导出...................................................................................................................1223.4.1 导出数据..........................................................................................................1223.4.2 导入数据..........................................................................................................124小结................................................................................................................127练习................................................................................................................128第4 章 SQL 套用基础........................................................................................1294.1 SQL 语言概述...............................................................................................................1314.1.1 SQL 语言特点..................................................................................................1314.1.2 SQL 分类..........................................................................................................1324.1.3 SQL 语句编写规则..........................................................................................1324.2 数据查询.......................................................................................................................1334.2.1 列查询..............................................................................................................1344.2.2 条件查询..........................................................................................................1354.2.3 算术运算符......................................................................................................1364.2.4 排序..................................................................................................................1374.2.5 联合查询..........................................................................................................1374.3 多表查询.......................................................................................................................1394.3.1 内连线..............................................................................................................1394.3.2 外连线..............................................................................................................1414.4 子查询...........................................................................................................................1434.4.1 单行和多行子查询..........................................................................................1454.4.2 多列子查询......................................................................................................1464.4.3 相关子查询......................................................................................................1474.5 系统函式.......................................................................................................................1484.5.1 单行函式..........................................................................................................1484.5.2 数据分组..........................................................................................................1654.6 数据操作.......................................................................................................................1704.6.1 插入数据..........................................................................................................1704.6.2 更新数据..........................................................................................................1734.6.3 删除数据..........................................................................................................1754.7 DML 事务操作.............................................................................................................176小结..................................................................................................................181练习...................................................................................................................181第5 章数据表对象.......................................................................................................1845.1 表..................................................................................................................................1865.1.1 创建表..............................................................................................................1865.1.2 修改表..............................................................................................................1905.1.3 删除表..............................................................................................................1915.2 索引...............................................................................................................................1925.2.1 创建索引..........................................................................................................1935.2.2 维护索引..........................................................................................................1945.2.3 索引使用原则..................................................................................................1955.3 约束...............................................................................................................................1965.3.1 创建约束..........................................................................................................1965.3.2 维护约束..........................................................................................................201小结..............................................................................................................203练习................................................................................................................203第6 章视图与序列..............................................................................................2066.1 视图概述.......................................................................................................................2086.2 建立视图.......................................................................................................................2106.2.1 简单视图..........................................................................................................2106.2.2 複杂视图..........................................................................................................2116.2.3 连线视图..........................................................................................................2126.2.4 唯读视图..........................................................................................................2136.2.5 CHECK 约束....................................................................................................2136.3 维护视图.......................................................................................................................2146.3.1 修改视图..........................................................................................................2146.3.2 重新编译视图..................................................................................................2146.3.3 删除视图..........................................................................................................2156.4 序列...............................................................................................................................2156.4.1 序列概述..........................................................................................................2156.4.2 使用序列..........................................................................................................2166.4.3 维护序列..........................................................................................................217小结.........................................................................................................218练习........................................................................................................218第7 章 PL/SQL 基础.....................................................................................2207.1 PL/SQL 简介.................................................................................................................2227.1.1 PL/SQL 概述....................................................................................................2227.1.2 PL/SQL 结构....................................................................................................2227.1.3 PL/SQL 块分类................................................................................................2257.1.4 注释..................................................................................................................2267.2 基本数据类型...............................................................................................................2277.2.1 标量变数..........................................................................................................2277.2.2 使用%TYPE.....................................................................................................2307.3 记录类型.......................................................................................................................2307.3.1 自定义PL/SQL 记录类型...............................................................................2317.3.2 %ROWTYPE 记录类型...................................................................................2327.4 集合类型.......................................................................................................................2337.4.1 PL/SQL 一维表................................................................................................2337.4.2 PL/SQL 多维表................................................................................................2357.4.3 嵌套表..............................................................................................................2357.4.4 可变数组..........................................................................................................2367.4.5 集合方法..........................................................................................................2377.5 运算符与表达式...........................................................................................................2407.5.1 运算符..............................................................................................................2407.5.2 表达式..............................................................................................................2417.6 流程控制语句...............................................................................................................2427.6.1 条件分支语句..................................................................................................2427.6.2 CASE 语句.......................................................................................................2457.6.3 循环语句..........................................................................................................2467.6.4 GOTO 语句......................................................................................................2487.7 异常处理.......................................................................................................................2497.7.1 异常简介..........................................................................................................2497.7.2 异常处理..........................................................................................................250小结.............................................................................................................254练习..............................................................................................................254第8 章 PL/SQL 进阶.............................................................................................2568.1 游标...............................................................................................................................2588.1.1 显式游标..........................................................................................................2588.1.2 使用游标..........................................................................................................2608.1.3 游标FOR 循环................................................................................................2638.1.4 游标修改和删除操作......................................................................................2648.2 游标变数.......................................................................................................................2668.2.1 游标变数定义..................................................................................................2668.2.2 游标变数操作..................................................................................................2688.3 存储过程.......................................................................................................................2698.3.1 存储过程概述..................................................................................................2698.3.2 无参存储过程..................................................................................................2708.3.3 带输入参数的存储过程...................................................................................2718.3.4 带输出参数的存储过程...................................................................................2748.3.5 带输入/输出参数的存储过程.........................................................................2778.3.6 维护存储过程..................................................................................................2788.4 自定义函式...................................................................................................................2788.4.1 函式概述..........................................................................................................2788.4.2 调用函式..........................................................................................................2808.4.3 函式返回类型..................................................................................................2808.4.4 维护函式..........................................................................................................2838.5 包..................................................................................................................................2838.5.1 包概述..............................................................................................................2848.5.2 调用包..............................................................................................................2858.5.3 使用集合类型..................................................................................................2888.5.4 重载..................................................................................................................2898.5.5 构造过程..........................................................................................................2908.5.6 维护包..............................................................................................................2918.6 触发器...........................................................................................................................2928.6.1 语句触发器......................................................................................................2938.6.2 行触发器..........................................................................................................2948.6.3 维护触发器......................................................................................................299小结..............................................................................................................300练习....................................................................................................................301第9 章事务管理与并发控制...........................................................................3059.1 事务的概念...................................................................................................................3079.1.1 事务概述..........................................................................................................3079.1.2 事务的状态......................................................................................................3079.1.3 事务的特性与套用...........................................................................................3089.2 事务控制.......................................................................................................................3109.2.1 搭建事务演示环境...........................................................................................3109.2.2 事务的开始与结束...........................................................................................3129.2.3 事务的提交......................................................................................................3139.2.4 事务的回滚与保存点.......................................................................................3149.2.5 事务隔离级别..................................................................................................3169.3 并发的概念...................................................................................................................3189.3.1 并发概述..........................................................................................................3199.3.2 锁、锁定和锁定协定......................................................................................3209.3.3 锁的粒度..........................................................................................................3259.4 锁在Oracle 中的套用...................................................................................................3269.4.1 Oracle 中锁的分类...........................................................................................3269.4.2 Oracle 中锁的级别...........................................................................................3299.4.3 Oracle 中的锁争用的检测与解决...................................................................331小结...............................................................................................................336练习....................................................................................................................337第10 章用户管理与安全......................................................................................33910.1 安全性概述.................................................................................................................34110.1.1 计算机安全性概述........................................................................................34110.1.2 资料库安全性控制........................................................................................34310.2 Oracle 中的用户管理..................................................................................................34610.2.1 资料库系统用户概述....................................................................................34610.2.2 Oracle 用户概述.............................................................................................34710.2.3 Oracle 用户管理.............................................................................................34810.3 Oracle 中的许可权管理..................................................................................................35310.3.1 Oracle 系统许可权.............................................................................................35310.3.2 Oracle 对象许可权.............................................................................................35710.4 Oracle 中的角色管理..................................................................................................35810.4.1 角色概述........................................................................................................35810.4.2 Oracle 中的角色概述.....................................................................................35910.4.3 Oracle 中的角色管理与使用.........................................................................360小结.........................................................................................................363练习..............................................................................................................363第11 章 Oracle 资料库备份与恢复...............................................................36511.1 资料库恢复与备份.....................................................................................................36711.1.1 资料库恢复概述............................................................................................36711.1.2 故障种类及恢复策略....................................................................................36911.1.3 Oracle 资料库的备份与恢复.........................................................................37111.2 Oracle 闪回技术..........................................................................................................37411.2.1 闪回查询........................................................................................................37611.2.2 闪回版本查询.................................................................................................38111.2.3 闪回事务查询.................................................................................................383小结..........................................................................................................................385练习.......................................................................................................................386实践篇.....................................................................................................................387实践1 Oracle 11g 资料库系统..............................................................................388实践指导..................................................................................................................388实践1.G.1.....................................................................................................................388实践1.G.2.....................................................................................................................402实践1.G.3.....................................................................................................................403知识拓展...........................................................................................................405资料库配置助手（DBCA） .......................................................................................405拓展练习...............................................................................................................410练习1.E.1.....................................................................................................................410练习1.E.2.....................................................................................................................411练习1.E.3.....................................................................................................................411实践2 资料库表对象...................................................................................................412实践指导.................................................................................................................412实践2.G.1.....................................................................................................................412实践2.G.2.....................................................................................................................414实践2.G.3.....................................................................................................................416实践2.G.4.....................................................................................................................419实践2.G.5.....................................................................................................................421实践2.G.6.....................................................................................................................422知识拓展...........................................................................................................4261. 表信息.....................................................................................................................4262. 索引信息.................................................................................................................4293. 约束信息.................................................................................................................4294. 多表插入.................................................................................................................430拓展练习...............................................................................................................432练习2.E.1.....................................................................................................................432练习2.E.2.....................................................................................................................432实践3 视图与序列.......................................................................................................433实践指导..............................................................................................................433实践3.G.1.....................................................................................................................433实践3.G.2.....................................................................................................................435实践3.G.3.....................................................................................................................438知识拓展.............................................................................................................440视图信息........................................................................................................440拓展练习............................................................................................................441练习3.E.1.....................................................................................................................441练习3.E.2.....................................................................................................................441练习3.E.3.....................................................................................................................441实践4 PL/SQL 基础................................................................................................442实践指导.....................................................................................................442实践4.G.1.....................................................................................................................442实践4.G.2.....................................................................................................................444知识拓展..........................................................................................................4461. PL/SQL 代码编写规则...........................................................................................4462. LOB 类型................................................................................................................4473. 集合运算.................................................................................................................4484. 批量操作.................................................................................................................4505. 异常处理函式.........................................................................................................4536. RAISE_APPLICATION_ERROR...........................................................................454拓展练习.......................................................................................................455练习4.E.1.....................................................................................................................455实践5 PL/SQL 进阶....................................................................................456实践指导...................................................................................................456实践5.G.1.....................................................................................................................456实践5.G.2.....................................................................................................................457实践5.G.3.....................................................................................................................461实践5.G.4.....................................................................................................................465实践5.G.5.....................................................................................................................469实践5.G.6.....................................................................................................................471知识拓展...............................................................................................................................4721. 批量提取.................................................................................................................4722. 包的纯度级别.........................................................................................................4743. 系统工具包.............................................................................................................4754. INSTEAD OF 触发器.............................................................................................4775. 系统事件触发器.....................................................................................................478拓展练习........................................................................................................482练习5.E.1.....................................................................................................................482练习5.E.2.....................................................................................................................482练习5.E.3.....................................................................................................................482练习5.E.4.....................................................................................................................482练习5.E.5.....................................................................................................................482练习5.E.6.....................................................................................................................482实践6 Oracle 资料库备份与恢复.........................................................................483实践指导..........................................................................................................483实践6.G.1.....................................................................................................................483实践6.G.2.....................................................................................................................488知识拓展........................................................................................................491系统许可权分类..............................................................................................................491拓展练习....................................................................................................495练习6.E.1.....................................................................................................................495练习6.E.2.....................................................................................................................495附录A 常用SQL*Plus 命令...................................................................................496附录B Oracle 数据隐式转换规则........................................................................505