Obsidian/Recognition/Programing/Oracle/일자 일괄 생성.md

SELECT TO_CHAR(TO_DATE('2021-01-01','YYYY-MM-DD') -1 + LEVEL, 'YYYYMMDD') AS "DATE" FROM DUAL CONNECT BY LEVEL <= 365;