oracle使用with语法可以提高查询效率

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

)