Oracle专题培训VIP免费

个人2011Oracle培训-专题主题详细描述hanshouzhong中国.上海目录一并行执行....................................................................................................................................4含义..................................................................................................................................4启用并行查询..................................................................................................................4启用PDML........................................................................................................................4PDML限制........................................................................................................................4PDDL范围.........................................................................................................................5PDDL说明.........................................................................................................................5二分析函数....................................................................................................................................5语法..................................................................................................................................5子句总结........................................................................................................................11窗口实验........................................................................................................................12分类................................................................................................................................13分析函数描述................................................................................................................13例子................................................................................................................................14三直接路径插入..........................................................................................................................36含义................................................................................................................................36支持类型........................................................................................................................36使用方法........................................................................................................................36限制................................................................................................................................36缺点................................................................................................................................36四物化视图..................................................................................................................................37五聚合函数扩展..........................................................................................................................37ROLLUP子句...................................................................................................................37CUBE子句.......................................................................................................................39GROUPING()函数与ROLLUP、CUBE的结合使用....