oracle generate calendar between two dates code example
Example: oracle sql generate list of days
SELECT trunc(sysdate - ROWNUM) DT
FROM DUAL
CONNECT BY ROWNUM < 366;
SELECT trunc(sysdate - ROWNUM) DT
FROM DUAL
CONNECT BY ROWNUM < 366;