SELECT TRUNC (SYSDATE - ROWNUM) dt FROM DUAL CONNECT BY ROWNUM < :ndates; /* from now on */ SELECT TRUNC (SYSDATE + ROWNUM - 2) dt FROM DUAL CONNECT BY ROWNUM < 100
SELECT TRUNC (SYSDATE - ROWNUM) dt FROM DUAL CONNECT BY ROWNUM < :ndates; /* from now on */ SELECT TRUNC (SYSDATE + ROWNUM - 2) dt FROM DUAL CONNECT BY ROWNUM < 100