무회 Blog

ORACLE_공휴일 입력 본문

DB

ORACLE_공휴일 입력

sucun 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
반응형
저작자표시 비영리 변경금지 (새창열림)

'DB' 카테고리의 다른 글

ORACLE 요일 , 분기 체크 , 월주차 , 한글설정  (0) 2022.12.29
ORACLE 월요일기준 연주차, 요일, 분기 계산  (0) 2022.12.29
PL(프로시저/Procedure)  (0) 2022.04.17
오라클 DB 조인이란:, LEFT JOIN,OUTER JOIN,INNER JOIN, NATURAL JOIN , USING  (0) 2021.07.04
DB(오라클 기준) 인덱스란  (0) 2021.07.04
'DB' Related Articles more
Comments