oracle使用with语法可以提高查询效率
select * from(with tdate as(select trunc(sysdate)-level aa from dualconnect by level <2000)select a.aa,b.aa bfrom tdate a,tdate bwhere a.aa=b.aa)
?
发布时间： 2012-07-24 17:47:58 作者： rapoo
oracle使用with语法可以提高查询效率
select * from(with tdate as(select trunc(sysdate)-level aa from dualconnect by level <2000)select a.aa,b.aa bfrom tdate a,tdate bwhere a.aa=b.aa)
?