Oracle 쿼리로 달력 만들기

코드

SELECT *
FROM    (
            SELECT MIN(DECODE(TO_CHAR(YM + LEVEL -1, 'd'), '1', LEVEL)) SUN
                , MIN(DECODE(TO_CHAR(YM + LEVEL -1, 'd'), '2', LEVEL)) MON
                , MIN(DECODE(TO_CHAR(YM + LEVEL -1, 'd'), '3', LEVEL)) TUE
                , MIN(DECODE(TO_CHAR(YM + LEVEL -1, 'd'), '4', LEVEL)) WED
                , MIN(DECODE(TO_CHAR(YM + LEVEL -1, 'd'), '5', LEVEL)) THU
                , MIN(DECODE(TO_CHAR(YM + LEVEL -1, 'd'), '6', LEVEL)) FRI
                , MIN(DECODE(TO_CHAR(YM + LEVEL -1, 'd'), '7', LEVEL)) SAT
            FROM    (
                        SELECT TO_DATE(TO_CHAR(SYSDATE, 'YYYYMM'), 'YYYYMM') YM FROM DUAL
                    )
            CONNECT BY LEVEL <= LAST_DAY (YM) - YM + 1
            GROUP BY TRUNC (YM + LEVEL, 'iw')
            ORDER BY 7
        )
;

참고 사이트 : www.gurubee.net/lecture/2863

[퀴즈] 달력만들기