오라클 쿼리로 달력 만들기

SELECT       TO_NUMBER(TO_CHAR(MIN(SUN), 'DD'))   "일"
           , TO_NUMBER(TO_CHAR(MIN(MON), 'DD'))   "월"
           , TO_NUMBER(TO_CHAR(MIN(TUE), 'DD'))   "화"
           , TO_NUMBER(TO_CHAR(MIN(WED), 'DD'))   "수"
           , TO_NUMBER(TO_CHAR(MIN(THU), 'DD'))   "목"
           , TO_NUMBER(TO_CHAR(MIN(FRI), 'DD'))   "금"
           , TO_NUMBER(TO_CHAR(MIN(SAT), 'DD'))   "토"
FROM   (   SELECT 
                    TRUNC(MONTH, 'D')      GUBN
                  , DECODE(WEEK, 1, MONTH) SUN
                  , DECODE(WEEK, 2, MONTH) MON
                  , DECODE(WEEK, 3, MONTH) TUE
                  , DECODE(WEEK, 4, MONTH) WED
                  , DECODE(WEEK, 5, MONTH) THU
                  , DECODE(WEEK, 6, MONTH) FRI
                  , DECODE(WEEK, 7, MONTH) SAT
            FROM  (SELECT MONTH
                         ,TO_CHAR(MONTH, 'D') WEEK
                     FROM(
                            SELECT DAY + LEVEL - 1 MONTH
                              FROM(
                                    SELECT TO_DATE('20140101', 'YYYYMMDD') DAY 
                                      FROM   DUAL)
                                    CONNECT BY LEVEL <= LAST_DAY(DAY) - DAY + 1
                          )
                   )
        )
GROUP BY GUBN
ORDER BY GUBN;