[출처] : http://cafe.naver.com/prodba/16202PRODBA 카페에서 지구인 님께서 올려주신 것. SELECT TARGET_DATE T_DATE, TO_CHAR(TARGET_DATE, 'DAY') T_DAYFROM ( SELECT ADD_MONTHS(TO_DATE(LEVEL, 'DDD'), 0) TARGET_DATE FROM DUAL CONNECT BY LEVEL