DB
ORACLE_공휴일 입력
최무회
2022. 12. 29. 22:08
SELECT '20220301' DT, '3.1절' CMT FROM DUAL
UNION ALL SELECT '20220101' DT, '신정' CMT FROM DUAL
UNION ALL SELECT '20220124' DT, '구정' CMT FROM DUAL
UNION ALL SELECT '20220127' DT, '신정대휴' CMT FROM DUAL
UNION ALL SELECT '20220415' DT, '총선' CMT FROM DUAL
UNION ALL SELECT '20220430' DT, '석탄일' CMT FROM DUAL
UNION ALL SELECT '20220505' DT, '키즈' CMT FROM DUAL
UNION ALL SELECT '20220815' DT, '광복절' CMT FROM DUAL
UNION ALL SELECT '20220817' DT, '대휴' CMT FROM DUAL
UNION ALL SELECT '20220930' DT, '추석' CMT FROM DUAL
UNION ALL SELECT '20221001' DT, '추석' CMT FROM DUAL
UNION ALL SELECT '20221002' DT, '추석' CMT FROM DUAL
UNION ALL SELECT '20221009' DT, '한글날' CMT FROM DUAL
UNION ALL SELECT '20221225' DT, '성탄절' CMT FROM DUAL