달력

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21

SELECT *  FROM (SELECT MIN(DECODE(TO_CHAR(YM + LEVEL - 1, 'd'), '1', LEVEL)) AS SUN             ,MIN(DECODE(TO_CHAR(YM + LEVEL - 1, 'd'), '1', LEVEL)) AS MON                            ,MIN(DECODE(TO_CHAR(YM + LEVEL - 1, 'd'), '1', LEVEL)) AS TUE                            ,MIN(DECODE(TO_CHAR(YM + LEVEL - 1, 'd'), '1', LEVEL)) AS WED                            ,MIN(DECODE(TO_CHAR(YM + LEVEL - 1, 'd'), '1', LEVEL)) AS THU                            ,MIN(DECODE(TO_CHAR(YM + LEVEL - 1, 'd'), '1', LEVEL)) AS FRI                            ,MIN(DECODE(TO_CHAR(YM + LEVEL - 1, 'd'), '1', LEVEL)) AS 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)      SUN  MON TUE WED THU  FRI  SAT  ---- --- --- --- ---- ---- ----  NULL   1   2   3    4    5    6     7   8   9  10   11   12   13    14  15  16  17   18   19   20    21  22  23  24   25   26   27    28  29  30  31 NULL NULL NULL