Oracle 원하는 날짜 데이터를 입력해보자(DUAL, CONNECT BY LEVEL)

1단계 : SELECT TO_DATE('19991231', 'YYYYMMDD') + LEVEL TEST FROM DUAL

              CONNECT BY LEVEL <= TO_DATE('20211231', 'YYYYMMDD') - TO_DATE('19991231', 'YYYYMMDD')

 

2단계 : INSERT INTO (YMD, WDAY) SELECT TO_CHAR(TEST, 'YYYYMMDD') YMD, TO_CHAR(TEST, 'DY') WDAY

 

완성

INSERT INTO CALENDAR (YMD, WDAY) SELECT TO_CHAR(TEST, 'YYYYMMDD') YMD, TO_CHAR(TEST, 'DY') WDAY

 FROM(

  SELECT TO_DATE('19991231', 'YYYYMMDD') + LEVEL TEST FROM DUAL

   CONNECT BY LEVEL <= TO_DATE('20211231', 'YYYYMMDD') - TO_DATE('19991231', 'YYYYMMDD')

 );