3
Oracle高效能SQL设计.pdf
免费下载
第 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
of 90
免费下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
1
2
PostgreSQL 缓存命中率低？可以这么做.doc
3
达梦数据2024年年度报告.pdf
4
北京大学 - DeepSeek与新媒体运营.pdf
5
centos7下oracle11.2.0.4 rac安装详细图文（虚拟机模拟多路径）.docx
6
【GoldenDB】一种分布式数据库变更数据检索方法、装置、设备及介质_CN202411914568.4_金篆信科有限责任公司.pdf
7
北京市公安局服务器、操作系统、数据库、工作站采购项目_G25050中标人投标分项报价表（第1包）.pdf
8
sql-课件-第4章-SQL高级应用.ppt
9
北京市公安局服务器、操作系统、数据库、工作站采购项目_G25050中标人投标分项报价表（第2包）.pdf
10
《太极计算机股份有限公司2024年年度报告》.pdf
相关文档
评论