1. 爱易网页
2. 数据库教程
3. oracle应用with语法可以提高查询效率

日期：2014-05-16　 浏览次数：20398 次

select * from

(with tdate as

(select trunc(sysdate)-level  aa from dual

connect by level <2000

)

select a.aa,b.aa b

from tdate a,tdate b

where a.aa=b.aa

)