select rownum id from dual connect by level<=10;
SELECT to_date(‘2014-12-01‘, ‘yyyy-mm-dd‘) + numtodsinterval(rownum - 1, ‘day‘) FROM DUAL CONNECT BY ROWNUM <= (to_date(‘2015-01-01‘, ‘yyyy-mm-dd‘) - to_date(‘2014-12-01‘, ‘yyyy-mm-dd‘))
原文：http://www.cnblogs.com/vvonline/p/4143250.html