SELECT TRUNC(TO_DATE('2010-01-02', 'yyyy-mm-dd')) + ROWNUM - 1 AS DATES FROM ALL_OBJECTS WHERE TRUNC(TO_DATE('2010-01-02', 'yyyy-mm-dd')) + ROWNUM - 1 < TRUNC(TO_DATE('2010-12-31', 'yyyy-mm-dd')) And Rownum = kssl+1 ;