[오라클] 주말 구하기

SELECT TO_CHAR(YYYYMMDD, 'YYYYMMDD') AS HOLIDAY_DT 
	 , DECODE( TO_CHAR(YYYYMMDD, 'd'), '1', '일요일', '7', '토요일') AS HOLIDAY_NM 
FROM
	(
	SELECT START_DATE + LEVEL - 1 YYYYMMDD
	FROM
		(
		SELECT TO_DATE('20200101', 'YYYYMMDD') START_DATE
			 , TO_DATE('20201231', 'YYYYMMDD') END_DATE
		FROM DUAL
		)
	CONNECT BY
		LEVEL <= END_DATE - START_DATE + 1 )
WHERE TO_CHAR(YYYYMMDD, 'd') IN (1, 7)
;

 

 

결과