2015年10月9日
Oracle Partition Outer Join 稠化报表
摘要： partition outer join实现将稀疏数据转为稠密数据,举例：with t as (select deptno, job, sum(sal) sum_sal from emp group by deptno, job),tt as (select distinct job from t)... 阅读全文
posted @ 2015-10-09 11:55 mellowsmile 阅读(628) 评论(0) 推荐(0) 编辑