WITH first_day AS ( SELECT TRUNC(SYSDATE,'MM') AS first_day FROM dual ),cal AS ( SELECT TO_CHAR(first_day + LEVEL -1,'D') 요일_숫자 , TO_CHAR(first_day + LEVEL -1,'MM-DD') 월일 , TO_CHAR(first_day + LEVEL -1,'IW') 주차 FROM first_day CONNECT BY first_day + LEVEL -1
