오라클 주차로 주차 날짜 구하기

SELECT
	TO_CHAR(EXAM_DATE, 'IW') AS WEEK_NO
	,TO_CHAR(EXAM_DATE, 'YYYYMMDD') AS EXAMDATE
	,DECODE(TO_CHAR(EXAM_DATE, 'D'), '1', '일', '2', '월', '3', '화', '4', '수', '5', '목', '6', '금', '토') AS WEEK_NAME
FROM
	(
		SELECT
			TO_DATE('20160321', 'YYYYMMDD') + (ROWNUM - 1) AS EXAM_DATE
		FROM
			DICTIONARY
		WHERE
			ROWNUM < 8
	) A