摘要：Oracle策略可以限制查询、修改、删除、新增等操作，刚接触，对查询做一个测试：参照http://blog.csdn.net/diyyong/article/details/19552637用法如下：begin -- Call the procedure sys.dbms_rls.add_pol... 阅读全文

摘要：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)... 阅读全文