select date'2017-01-01' + (rownum - 1) curdate from dual connect by rownum <= (sysdate - date'2017-01-01' + 1)