oracle教程

sunzhenlin2008Oracle8i数据库基础(SQL和PL_SQL).zip 601.62KB

资源文件列表:

Oracle8i数据库基础(SQL和PL_SQL).zip 大约有1个文件

Oracle8i数据库基础(SQL和PL_SQL).doc 3.32MB

资源介绍:

初学者不错的oracle教程

<html xmlns="http://www.w3.org/1999/xhtml"><meta charset="utf-8"><meta name="generator" content="pdf2htmlEX"><meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"><link rel="stylesheet" href="/image.php?url=https://csdnimg.cn/release/download_crawler_static/css/base.min.css"><link rel="stylesheet" href="/image.php?url=https://csdnimg.cn/release/download_crawler_static/css/fancy.min.css"><link rel="stylesheet" href="/image.php?url=https://csdnimg.cn/release/download_crawler_static/500333/raw.css"><script src="/image.php?url=https://csdnimg.cn/release/download_crawler_static/js/compatibility.min.js"></script><script src="/image.php?url=https://csdnimg.cn/release/download_crawler_static/js/pdf2htmlEX.min.js"></script><script>try{pdf2htmlEX.defaultViewer = new pdf2htmlEX.Viewer({});}catch(e){}</script><div id="sidebar" style="display: none"><div id="outline"></div></div><div id="pf1" class="pf w0 h0" data-page-no="1"><div class="pc pc1 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="/image.php?url=https://csdnimg.cn/release/download_crawler_static/500333/bg1.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x1 h3 y2 ff1 fs0 fc0 sc0 ls0 ws0"> Oracle8i 数据库基础</div><div class="t m0 x1 h3 y3 ff1 fs0 fc0 sc0 ls0 ws0"> (初稿)</div><div class="t m0 x1 h4 y4 ff1 fs1 fc0 sc0 ls0 ws0"> 赵元杰</div><div class="t m0 x1 h5 y5 ff1 fs2 fc0 sc0 ls0 ws0"> 2002 年 3 月 5 日</div></div></div><div class="pi" data-data='{"ctm":[1.611850,0.000000,0.000000,1.611850,0.000000,0.000000]}'></div></div></html><div id="pf2" class="pf w0 h0" data-page-no="2"><div class="pc pc2 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="/image.php?url=https://csdnimg.cn/release/download_crawler_static/500333/bg2.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x1 h6 y6 ff3 fs3 fc0 sc0 ls0 ws0"> 前 言</div><div class="t m0 x1 h6 y7 ff4 fs3 fc0 sc0 ls0 ws0"> 本讲稿(ORACLE8i 数据库基础)是作者在多年的工作和授课中的总结，主要包括两个部分，</div><div class="t m0 x1 h6 y8 ff2 fs3 fc0 sc0 ls0 ws0">第一部分是 ORACLE SQL*PLUS 基础，主要讲述 ORACLE 应用系统设计的基本知识和给出</div><div class="t m0 x1 h6 y9 ff2 fs3 fc0 sc0 ls0 ws0">一 些 有 用 的 实 例 ； 第 二 部 分 是 介 绍 ORACLE PL/SQL 知 识 ， 主 要 讲 述 ORACLE 数 据</div><div class="t m0 x1 h6 ya ff2 fs3 fc0 sc0 ls0 ws0">库 PL/SQL 程序设计所用到基本知识，这部分给出进行应用设计所必需的基础知识。这两部</div><div class="t m0 x1 h6 yb ff2 fs3 fc0 sc0 ls0 ws0">分的内容都尽可能做到内容简洁而全面。特点是，1.用简单明了的语句对解释各个部分的内</div><div class="t m0 x1 h6 yc ff2 fs3 fc0 sc0 ls0 ws0">容，省去一些理论性的解释；2.给出作者在应用设计和开发中的一些具体的例子，为软件人</div><div class="t m0 x1 h6 yd ff2 fs3 fc0 sc0 ls0 ws0">员提供一些借鉴，省去查阅大量资料的时间。3.给出了许多资料所没有提供的一些使用技巧，</div><div class="t m0 x1 h6 ye ff2 fs3 fc0 sc0 ls0 ws0">如导出触发器等。总之，内容基本上包括当前 Oracle8I 的最新内容。同时也覆盖了最新的</div><div class="t m0 x1 h6 yf ff4 fs3 fc0 sc0 ls0 ws0">ORACLE8i OCP 培训大纲的内容。不仅包含 ORACLE 程序设计人员、DBA 所必须掌握的知</div><div class="t m0 x1 h6 y10 ff2 fs3 fc0 sc0 ls0 ws0">识，而且还含盖了系统分析员所要求的内容。与本书（讲稿）相伴的还有《Oracle8I 初级管</div><div class="t m0 x1 h6 y11 ff2 fs3 fc0 sc0 ls0 ws0">理员》和《Oracle8I 高级管理员》。</div><div class="t m0 x1 h6 y12 ff4 fs3 fc0 sc0 ls0 ws0"> 全书内容简练实用，可作为 ORACLE 数据库管理人员参考，也可作为应用开发人员和系</div><div class="t m0 x1 h6 y13 ff2 fs3 fc0 sc0 ls0 ws0">统分析与 设计 人员 以及 大学 计算 机专 业教 学的 参考 资料 。由 于作 者水 平所 限， 加之</div><div class="t m0 x1 h6 y14 ff4 fs3 fc0 sc0 ls0 ws0">ORACLE 的产品与内容的浩瀚，在资料的整理与收集中可能有不少错误和不妥之处，希望</div><div class="t m0 x1 h6 y15 ff2 fs3 fc0 sc0 ls0 ws0">读者给予批评制正。</div></div><div class="t m0 x2 h7 y16 ff4 fs4 fc0 sc0 ls0 ws0">2</div></div><div class="pi" data-data='{"ctm":[1.611850,0.000000,0.000000,1.611850,0.000000,0.000000]}'></div></div><div id="pf3" class="pf w0 h0" data-page-no="3"><div class="pc pc3 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="/image.php?url=https://csdnimg.cn/release/download_crawler_static/500333/bg3.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x1 h6 y17 ff3 fs3 fc0 sc0 ls0 ws0"> 目 录</div><div class="t m0 x1 h6 y8 ff2 fs3 fc0 sc0 ls0 ws0">第一部分 Oracle SQL*PLUS 基础...................................................................................................22</div><div class="t m0 x1 h6 y9 ff2 fs3 fc0 sc0 ls0 ws0">第一章 Oracle 数据库基础................................................................................................................22</div><div class="t m0 x3 h6 ya ff4 fs3 fc0 sc0 ls0 ws0">§1.1 理解关系数据库系统（RDBMS）..................................................................................22</div><div class="t m0 x4 h6 yb ff4 fs3 fc0 sc0 ls0 ws0">§1.1.1 关系模型..................................................................................................................22</div><div class="t m0 x4 h6 yc ff4 fs3 fc0 sc0 ls0 ws0">§1.1.2 Codd 十二法则........................................................................................................23</div><div class="t m0 x3 h6 yd ff4 fs3 fc0 sc0 ls0 ws0">§1.2 关系数据库系统（RDBMS）的组成..............................................................................23</div><div class="t m0 x4 h6 ye ff4 fs3 fc0 sc0 ls0 ws0">§1.2.1 RDBMS 内核...........................................................................................................24</div><div class="t m0 x4 h6 yf ff4 fs3 fc0 sc0 ls0 ws0">§1.2.2 数据字典概念..........................................................................................................24</div><div class="t m0 x3 h6 y10 ff4 fs3 fc0 sc0 ls0 ws0">§1.3 SQL、SQL*Plus 及 PL/SQL.............................................................................................24</div><div class="t m0 x4 h6 y11 ff4 fs3 fc0 sc0 ls0 ws0">§1.3.1 SQL 和 SQL*PLUS 的差别....................................................................................24</div><div class="t m0 x4 h6 y12 ff4 fs3 fc0 sc0 ls0 ws0">§1.3.2 PL/SQL 语言...........................................................................................................26</div><div class="t m0 x3 h6 y13 ff4 fs3 fc0 sc0 ls0 ws0">§1.4 登录到 SQL*PLUS............................................................................................................26</div><div class="t m0 x4 h6 y14 ff4 fs3 fc0 sc0 ls0 ws0">§1.4.1 UNIX 环境...............................................................................................................27</div><div class="t m0 x4 h6 y15 ff4 fs3 fc0 sc0 ls0 ws0">§1.4.2 Windows NT 和 WINDOWS/2000 环境................................................................29</div><div class="t m0 x3 h6 y18 ff4 fs3 fc0 sc0 ls0 ws0">§1.5 常用 SQL*PLUS 附加命令简介.......................................................................................31</div><div class="t m0 x4 h6 y19 ff4 fs3 fc0 sc0 ls0 ws0">§1.5.1 登录到 SQL*PLUS.................................................................................................31</div><div class="t m0 x4 h6 y1a ff4 fs3 fc0 sc0 ls0 ws0">§1.5.2 EXIT 和 QUIT.........................................................................................................32</div><div class="t m0 x4 h6 y1b ff4 fs3 fc0 sc0 ls0 ws0">§1.5.3 DESCRIBE(显示表、视图结构)...........................................................................32</div><div class="t m0 x4 h6 y1c ff4 fs3 fc0 sc0 ls0 ws0">§1.5.4 LIST(列出)命令......................................................................................................33</div><div class="t m0 x4 h6 y1d ff4 fs3 fc0 sc0 ls0 ws0">§1.5.5 Change(替换字符串)命令......................................................................................33</div><div class="t m0 x4 h6 y1e ff4 fs3 fc0 sc0 ls0 ws0">§1.5.6 Append（追加字符串）命令.................................................................................34</div><div class="t m0 x4 h6 y1f ff4 fs3 fc0 sc0 ls0 ws0">§1.5.7 Save 保存当前缓冲区命令到文件.........................................................................35</div><div class="t m0 x4 h6 y20 ff4 fs3 fc0 sc0 ls0 ws0">§1.5.8 GET 将命令文件读到缓冲区.................................................................................35</div><div class="t m0 x4 h6 y21 ff4 fs3 fc0 sc0 ls0 ws0">§1.5.9 SPOOL 将信息记录到文件中................................................................................35</div><div class="t m0 x4 h6 y22 ff4 fs3 fc0 sc0 ls0 ws0">§1.5.10 再运行当前缓冲区的命令...................................................................................36</div><div class="t m0 x3 h6 y23 ff4 fs3 fc0 sc0 ls0 ws0">§1.6 常用数据字典简介.............................................................................................................37</div><div class="t m0 x3 h6 y24 ff4 fs3 fc0 sc0 ls0 ws0">§1.7 ORACLE 数据类型............................................................................................................38</div><div class="t m0 x3 h6 y25 ff4 fs3 fc0 sc0 ls0 ws0">§1.8 SQL 语句基础....................................................................................................................44</div><div class="t m0 x4 h6 y26 ff4 fs3 fc0 sc0 ls0 ws0">§1.8.1 SQL 语句所用符号.................................................................................................44</div><div class="t m0 x4 h6 y27 ff4 fs3 fc0 sc0 ls0 ws0">§1.8.2 简单 select 查询.......................................................................................................46</div><div class="t m0 x3 h6 y28 ff4 fs3 fc0 sc0 ls0 ws0">§1.9 伪列及伪表.........................................................................................................................46</div><div class="t m0 x3 h6 y29 ff4 fs3 fc0 sc0 ls0 ws0">§1.10 使用 SQL Worksheet 工作...............................................................................................47</div><div class="t m0 x1 h6 y2a ff2 fs3 fc0 sc0 ls0 ws0">第二章 查询基础................................................................................................................................51</div><div class="t m0 x3 h6 y2b ff4 fs3 fc0 sc0 ls0 ws0">§2.1 SELECT 语句.....................................................................................................................51</div><div class="t m0 x3 h6 y2c ff4 fs3 fc0 sc0 ls0 ws0">§2.2 SQL 中的单记录函数........................................................................................................51</div><div class="t m0 x4 h6 y2d ff4 fs3 fc0 sc0 ls0 ws0">§2.2.1 单记录字符函数.....................................................................................................52</div><div class="t m0 x4 h6 y2e ff4 fs3 fc0 sc0 ls0 ws0">§2.2.2 单记录数字函数.....................................................................................................57</div><div class="t m0 x4 h6 y2f ff4 fs3 fc0 sc0 ls0 ws0">§2.2.3 单记录日期函数.....................................................................................................63</div><div class="t m0 x4 h6 y30 ff4 fs3 fc0 sc0 ls0 ws0">§2.2.4 单记录转换函数.....................................................................................................66</div><div class="t m0 x4 h6 y31 ff4 fs3 fc0 sc0 ls0 ws0">§2.2.5 其它的单记录函数.................................................................................................70</div><div class="t m0 x3 h6 y32 ff4 fs3 fc0 sc0 ls0 ws0">§2.3 SQL 中的组函数................................................................................................................75</div></div><div class="t m0 x2 h7 y16 ff4 fs4 fc0 sc0 ls0 ws0">3</div><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a></div><div class="pi" data-data='{"ctm":[1.611850,0.000000,0.000000,1.611850,0.000000,0.000000]}'></div></div><div id="pf4" class="pf w0 h0" data-page-no="4"><div class="pc pc4 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="/image.php?url=https://csdnimg.cn/release/download_crawler_static/500333/bg4.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x4 h6 y6 ff4 fs3 fc0 sc0 ls0 ws0">§2.3.1 多记录组函数..........................................................................................................75</div><div class="t m0 x4 h6 y17 ff4 fs3 fc0 sc0 ls0 ws0">§2.3.2 带 GROUP BY 的计算...........................................................................................76</div><div class="t m0 x4 h6 y7 ff4 fs3 fc0 sc0 ls0 ws0">§2.3.3 用 HAVING 来限制分组的计算............................................................................77</div><div class="t m0 x3 h6 y8 ff4 fs3 fc0 sc0 ls0 ws0">§2.4 控制和格式化输出.............................................................................................................78</div><div class="t m0 x4 h6 y9 ff4 fs3 fc0 sc0 ls0 ws0">§2.4.1 用 ORDER BY 子句来对结果进行排序...............................................................78</div><div class="t m0 x4 h6 ya ff4 fs3 fc0 sc0 ls0 ws0">§2.4.2 用 BREAK 命令 来对结果进行排列....................................................................78</div><div class="t m0 x4 h6 yb ff4 fs3 fc0 sc0 ls0 ws0">§2.4.3 用 COMPUTE 命令对结果进行格式化................................................................81</div><div class="t m0 x3 h6 yc ff4 fs3 fc0 sc0 ls0 ws0">§2.5 配置会话环境.....................................................................................................................84</div><div class="t m0 x4 h6 yd ff4 fs3 fc0 sc0 ls0 ws0">§2.5.1 ARRAYSIZE（取回的行数）...............................................................................85</div><div class="t m0 x4 h6 ye ff4 fs3 fc0 sc0 ls0 ws0">§2.5.2 AUTOCOMMIT(自动提交)...................................................................................85</div><div class="t m0 x4 h6 yf ff4 fs3 fc0 sc0 ls0 ws0">§2.5.3 LINESIZE(行显示宽度).........................................................................................85</div><div class="t m0 x4 h6 y10 ff4 fs3 fc0 sc0 ls0 ws0">§2.5.4 LONG(长类型显示字节数)....................................................................................85</div><div class="t m0 x4 h6 y11 ff4 fs3 fc0 sc0 ls0 ws0">§2.5.5 PAGESIZE(页行数)................................................................................................86</div><div class="t m0 x4 h8 y12 ff4 fs3 fc0 sc0 ls0 ws0">§2.5.6 PAUSE(暂停)...........................................................................................................86</div><div class="t m0 x4 h6 y13 ff4 fs3 fc0 sc0 ls0 ws0">§2.5.7 SPACE(列间空格)...................................................................................................86</div><div class="t m0 x4 h6 y14 ff4 fs3 fc0 sc0 ls0 ws0">§2.5.8 Termout (启/停屏幕显示).......................................................................................86</div><div class="t m0 x4 h6 y15 ff4 fs3 fc0 sc0 ls0 ws0">§2.5.9 ECHO (启/停命令显示)..........................................................................................87</div><div class="t m0 x4 h8 y18 ff4 fs3 fc0 sc0 ls0 ws0">§2.5.10 TRANSACTION (启动事务)...............................................................................87</div><div class="t m0 x4 h6 y19 ff4 fs3 fc0 sc0 ls0 ws0">§2.5.11 SHOW ALL(列出所有参数).................................................................................87</div><div class="t m0 x3 h6 y1a ff4 fs3 fc0 sc0 ls0 ws0">§2.6 格式化输出.........................................................................................................................89</div><div class="t m0 x4 h6 y1b ff4 fs3 fc0 sc0 ls0 ws0">§2.6.1 一般数据的格式化输出.........................................................................................89</div><div class="t m0 x4 h6 y1c ff4 fs3 fc0 sc0 ls0 ws0">§2.6.2 日期的格式化输出.................................................................................................91</div><div class="t m0 x3 h6 y1d ff4 fs3 fc0 sc0 ls0 ws0">§2.7 加标题.................................................................................................................................92</div><div class="t m0 x3 h6 y1e ff4 fs3 fc0 sc0 ls0 ws0">§2.8 建立简单报告.....................................................................................................................92</div><div class="t m0 x3 h6 y1f ff4 fs3 fc0 sc0 ls0 ws0">§2.9 输入变量.............................................................................................................................94</div><div class="t m0 x1 h6 y20 ff2 fs3 fc0 sc0 ls0 ws0">第三章 表及索引的定义操作...........................................................................................................97</div><div class="t m0 x3 h6 y21 ff4 fs3 fc0 sc0 ls0 ws0">§3.1 建立表结构.........................................................................................................................97</div><div class="t m0 x4 h6 y22 ff4 fs3 fc0 sc0 ls0 ws0">§3.1.1 建立表结构命令.....................................................................................................97</div><div class="t m0 x4 h6 y23 ff4 fs3 fc0 sc0 ls0 ws0">§3.1.2 建立表结构例子.....................................................................................................99</div><div class="t m0 x4 h6 y24 ff4 fs3 fc0 sc0 ls0 ws0">§3.1.3 建立临时表结构...................................................................................................100</div><div class="t m0 x3 h6 y25 ff4 fs3 fc0 sc0 ls0 ws0">§3.3 修改表结构.......................................................................................................................101</div><div class="t m0 x4 h6 y26 ff4 fs3 fc0 sc0 ls0 ws0">§3.3.1 修改表结构命令...................................................................................................102</div><div class="t m0 x4 h6 y27 ff4 fs3 fc0 sc0 ls0 ws0">§3.3.2 修改表结构例子...................................................................................................102</div><div class="t m0 x4 h6 y28 ff4 fs3 fc0 sc0 ls0 ws0">§3.3.3 删除表结构............................................................................................................104</div><div class="t m0 x4 h6 y29 ff4 fs3 fc0 sc0 ls0 ws0">§3.3.4 使用 CHECK 作限制约束....................................................................................105</div><div class="t m0 x4 h6 y2a ff4 fs3 fc0 sc0 ls0 ws0">§3.3.5 使用 UNRECOVERABLE 创建表.......................................................................105</div><div class="t m0 x4 h6 y2b ff4 fs3 fc0 sc0 ls0 ws0">§3.3.6 将表移动到新的数据段或新的表空间...............................................................106</div><div class="t m0 x4 h6 y2c ff4 fs3 fc0 sc0 ls0 ws0">§3.3.7 手工分配表的存储空间.......................................................................................107</div><div class="t m0 x4 h6 y2d ff4 fs3 fc0 sc0 ls0 ws0">§3.3.8 标记不使用的列和删除不使用的列...................................................................108</div><div class="t m0 x3 h6 y2e ff4 fs3 fc0 sc0 ls0 ws0">§3.3 主键...................................................................................................................................110</div><div class="t m0 x4 h6 y2f ff4 fs3 fc0 sc0 ls0 ws0">§3.3.1 创建主键................................................................................................................110</div><div class="t m0 x4 h6 y30 ff4 fs3 fc0 sc0 ls0 ws0">§3.3.2 改变主键................................................................................................................112</div><div class="t m0 x4 h6 y31 ff4 fs3 fc0 sc0 ls0 ws0">§3.3.3 删除主键................................................................................................................113</div><div class="t m0 x3 h6 y32 ff4 fs3 fc0 sc0 ls0 ws0">§3.4 外部键...............................................................................................................................113</div></div><div class="t m0 x2 h7 y16 ff4 fs4 fc0 sc0 ls0 ws0">4</div></div><div class="pi" data-data='{"ctm":[1.611850,0.000000,0.000000,1.611850,0.000000,0.000000]}'></div></div><div id="pf5" class="pf w0 h0" data-page-no="5"><div class="pc pc5 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="/image.php?url=https://csdnimg.cn/release/download_crawler_static/500333/bg5.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x4 h6 y6 ff4 fs3 fc0 sc0 ls0 ws0">§3.4.1 建立外部键............................................................................................................114</div><div class="t m0 x4 h6 y17 ff4 fs3 fc0 sc0 ls0 ws0">§3.4.2 修改外部键............................................................................................................116</div><div class="t m0 x4 h6 y7 ff4 fs3 fc0 sc0 ls0 ws0">§3.4.3 删除外部键............................................................................................................116</div><div class="t m0 x3 h8 y8 ff4 fs3 fc0 sc0 ls0 ws0">§3.5 索引...................................................................................................................................116</div><div class="t m0 x4 h8 y9 ff4 fs3 fc0 sc0 ls0 ws0">§3.5.1 建立索引................................................................................................................116</div><div class="t m0 x4 h8 ya ff4 fs3 fc0 sc0 ls0 ws0">§3.5.2 修改索引................................................................................................................118</div><div class="t m0 x4 h8 yb ff4 fs3 fc0 sc0 ls0 ws0">§3.5.3 删除索引................................................................................................................119</div><div class="t m0 x3 h6 yc ff4 fs3 fc0 sc0 ls0 ws0">§3.6 新索引类型.......................................................................................................................119</div><div class="t m0 x4 h6 yd ff4 fs3 fc0 sc0 ls0 ws0">§3.6.1 基于函数的索引....................................................................................................119</div><div class="t m0 x4 h8 ye ff4 fs3 fc0 sc0 ls0 ws0">§3.6.2 反向键索引............................................................................................................121</div><div class="t m0 x4 h6 yf ff4 fs3 fc0 sc0 ls0 ws0">§3.6.3 索引组织表............................................................................................................121</div><div class="t m0 x3 h6 y10 ff4 fs3 fc0 sc0 ls0 ws0">§3.7 抽象数据类型的使用......................................................................................................123</div><div class="t m0 x3 h6 y11 ff4 fs3 fc0 sc0 ls0 ws0">§3.8 大数据类型的使用...........................................................................................................124</div><div class="t m0 x4 h6 y12 ff4 fs3 fc0 sc0 ls0 ws0">§3.8.1 可用数据类型.......................................................................................................124</div><div class="t m0 x4 h6 y13 ff4 fs3 fc0 sc0 ls0 ws0">§3.8.2 为 LOB 数据类型指定存储..................................................................................124</div><div class="t m0 x4 h6 y14 ff4 fs3 fc0 sc0 ls0 ws0">§3.8.3 操作和检索 LOB 数据..........................................................................................126</div><div class="t m0 x3 h6 y15 ff4 fs3 fc0 sc0 ls0 ws0">§3.9 表和索引有关的数据字典..............................................................................................129</div><div class="t m0 x4 h6 y18 ff4 fs3 fc0 sc0 ls0 ws0">§3.9.1 表和索引数据字典...............................................................................................129</div><div class="t m0 x4 h6 y19 ff4 fs3 fc0 sc0 ls0 ws0">§3.9.2 数据字典查询例子...............................................................................................129</div><div class="t m0 x1 h6 y1a ff2 fs3 fc0 sc0 ls0 ws0">第四章 视图、同义词和序列.........................................................................................................133</div><div class="t m0 x3 h6 y1b ff4 fs3 fc0 sc0 ls0 ws0">§4.1 视图...................................................................................................................................133</div><div class="t m0 x4 h6 y1c ff4 fs3 fc0 sc0 ls0 ws0">§4.1.1 使用视图来修改表中数据...................................................................................133</div><div class="t m0 x4 h6 y1d ff4 fs3 fc0 sc0 ls0 ws0">§4.1.2 创建一个新视图...................................................................................................133</div><div class="t m0 x4 h6 y1e ff4 fs3 fc0 sc0 ls0 ws0">§4.1.3 删除一个视图.......................................................................................................135</div><div class="t m0 x4 h6 y1f ff4 fs3 fc0 sc0 ls0 ws0">§4.1.4 改变视图................................................................................................................136</div><div class="t m0 x3 h6 y20 ff4 fs3 fc0 sc0 ls0 ws0">§4.2 实体视图(MATERIALIZED VIEW)...............................................................................136</div><div class="t m0 x4 h6 y21 ff4 fs3 fc0 sc0 ls0 ws0">§4.2.1 创建实体视图.......................................................................................................136</div><div class="t m0 x4 h6 y22 ff4 fs3 fc0 sc0 ls0 ws0">§4.2.2 创建实体视图日志...............................................................................................142</div><div class="t m0 x4 h6 y23 ff4 fs3 fc0 sc0 ls0 ws0">§4.2.3 修改实体视图.......................................................................................................144</div><div class="t m0 x4 h6 y24 ff4 fs3 fc0 sc0 ls0 ws0">§4.2.4 修改实体视图日志...............................................................................................145</div><div class="t m0 x3 h6 y25 ff4 fs3 fc0 sc0 ls0 ws0">§4.3 序号(sequence).................................................................................................................146</div><div class="t m0 x4 h6 y26 ff4 fs3 fc0 sc0 ls0 ws0">§4.3.1 建立序号................................................................................................................146</div><div class="t m0 x4 h6 y27 ff4 fs3 fc0 sc0 ls0 ws0">§4.3.2 修改序号................................................................................................................147</div><div class="t m0 x4 h6 y28 ff4 fs3 fc0 sc0 ls0 ws0">§4.3.3 使用序号................................................................................................................147</div><div class="t m0 x4 h6 y29 ff4 fs3 fc0 sc0 ls0 ws0">§4.3.4 删除序号................................................................................................................148</div><div class="t m0 x3 h6 y2a ff4 fs3 fc0 sc0 ls0 ws0">§4.4 同义词...............................................................................................................................148</div><div class="t m0 x4 h6 y2b ff4 fs3 fc0 sc0 ls0 ws0">§4.4.1 建立同义词............................................................................................................148</div><div class="t m0 x4 h6 y2c ff4 fs3 fc0 sc0 ls0 ws0">§4.4.2 删除同义词............................................................................................................149</div><div class="t m0 x3 h6 y2d ff4 fs3 fc0 sc0 ls0 ws0">§4.5 视图、同义词和序列有关的数据字典..........................................................................150</div><div class="t m0 x1 h6 y2e ff2 fs3 fc0 sc0 ls0 ws0">第五章 簇与分区..............................................................................................................................151</div><div class="t m0 x3 h8 y2f ff4 fs3 fc0 sc0 ls0 ws0">§5.1 簇( cluster ).......................................................................................................................151</div><div class="t m0 x4 h6 y30 ff4 fs3 fc0 sc0 ls0 ws0">§5.1.0 簇概念....................................................................................................................151</div><div class="t m0 x4 h8 y31 ff4 fs3 fc0 sc0 ls0 ws0">§5.1.1 建立簇....................................................................................................................153</div><div class="t m0 x4 h8 y32 ff4 fs3 fc0 sc0 ls0 ws0">§5.1.2 改变簇....................................................................................................................156</div></div><div class="t m0 x2 h7 y16 ff4 fs4 fc0 sc0 ls0 ws0">5</div></div><div class="pi" data-data='{"ctm":[1.611850,0.000000,0.000000,1.611850,0.000000,0.000000]}'></div></div>