復制代碼 代碼如下:

select rownum as dateIndex,to_date('20090701','yyyy-mm-dd')+ rownum-1 AS DATE_ FROM DUAL CONNECT BY LEVEL >= 1 AND LEVEL <=(TO_DATE('20090731','yyyy-mm-dd')-TO_DATE('20090701','yyyy-mm-dd')+1)