select rownum id from dual connect by level<=10;

SELECT to_date(‘2014-12-01‘, ‘yyyy-mm-dd‘) +       numtodsinterval(rownum - 1, ‘day‘)  FROM DUALCONNECT BY ROWNUM <= (to_date(‘2015-01-01‘, ‘yyyy-mm-dd‘) -           to_date(‘2014-12-01‘, ‘yyyy-mm-dd‘))