Oracle advanced sql by dj mailto:dingjunlove@163.com
第 3 页 共 90 页
目 录
1.集合操作··········································································································· 5
1.1.UNION 和 UNION ALL ························································································· 5
1.2.INTERSECT 交集操作 ························································································ 6
1.3. MINUS 差集操作····························································································· 6
1.4.集合操作实例································································································ 7
2.EXISTS 和 NOT EXISTS 的使用 ············································································ 9
2.1. EXISTS 的使用 ······························································································· 9
2.2 NOT EXISTS 的使用························································································· 10
3.WITH 子句·······································································································11
3.1 WITH 基础 ····································································································11
3.2 11G R2WITH 新特性······················································································· 16
3.3 WITH 对执行计划的影响 ················································································· 16
4.MERGE INTO 合并资料····················································································· 17
5.层次查询(HIERARICAL RETRIVAL)···································································· 20
6.DECODE 函数和行列互换 ·················································································· 32
7.CASE 表达式 ··································································································· 40
7.1 CASE 简介 ··································································································· 40
7.2 两种 CASE ·································································································· 41
7.3 综合实例 ··································································································· 42
8.ROWNUM—TOP-N 分析 ··················································································· 44
9.相关子查询和非相关子查询 ················································································· 49
10.增强的 GROUP BY ·························································································· 50
11.分析函数(ANALYTICAL FUNCTIONS)································································ 51
11.1 背景知识·································································································· 51
11.2 分析函数基础···························································································· 51
11.3 分析函数的使用························································································· 60
12.ROWID 的使用······························································································· 71
13. ORACLE10G 正则表达式 ················································································· 71
14.使用 HINT ····································································································· 71
15.PARITION 分区 ······························································································ 71
16.并行操作 ······································································································· 71
17.扩展 DDL 和 DML 语句 ···················································································· 72
