CODE EXAMPLE FOR SQL

oracle list dates between

-- Oracle: List of last dates
SELECT trunc(sysdate - ROWNUM) AS CAL_DATE
FROM DUAL
CONNECT BY ROWNUM < 30;