oracle sql generate list of days
snippet in sql

oracle sql generate list of days

user7718

SELECT trunc(sysdate - ROWNUM) DT
FROM DUAL
CONNECT BY ROWNUM < 366;