Oracle 案例
zhangxiaobo5152
追求 常清静
展开
-
autotrace 例子
sec@ora10g> set autotrace onsec@ora10g> select * from t where x = 'secooler';X--------secoolerExecution Plan----------------------------------------------------------Plan has转载 2016-01-12 16:59:45 · 256 阅读 · 0 评论 -
差集与交集
检验minus差集作用:(输出1)select a from(select 1 a from dual union all select 1 a from dual union allselect 3 a from dual union all select 4 a from dual ) t1minusselect a from(select 21 a from原创 2016-02-26 17:01:17 · 558 阅读 · 0 评论