티스토리 뷰

DATABASE

[Oracle] 오라클 달력출력

RAHM 2016. 9. 30. 13:56

SELECT MIN (DECODE (TO_CHAR (DAYS, 'D'), 1, TO_CHAR (DAYS, 'FMDD'))) AS SUN,
         MIN (DECODE (TO_CHAR (DAYS, 'D'), 2, TO_CHAR (DAYS, 'FMDD'))) AS MON,
         MIN (DECODE (TO_CHAR (DAYS, 'D'), 3, TO_CHAR (DAYS, 'FMDD'))) AS TUE,
         MIN (DECODE (TO_CHAR (DAYS, 'D'), 4, TO_CHAR (DAYS, 'FMDD'))) AS WED,
         MIN (DECODE (TO_CHAR (DAYS, 'D'), 5, TO_CHAR (DAYS, 'FMDD'))) AS THU,
         MIN (DECODE (TO_CHAR (DAYS, 'D'), 6, TO_CHAR (DAYS, 'FMDD'))) AS FRI,
         MIN (DECODE (TO_CHAR (DAYS, 'D'), 7, TO_CHAR (DAYS, 'FMDD'))) AS SAT
  FROM   ( SELECT BASE_MON + LEVEL - 1 AS DAYS,
                  ( TRUNC(BASE_MON + LEVEL - 1, 'D') - TRUNC(TRUNC(BASE_MON + LEVEL - 1, 'Y'), 'D') ) / 7 + 1 AS WEEK_GRP
           FROM   ( SELECT TO_DATE ('2009' || '10', 'YYYYMM') AS BASE_MON FROM DUAL )
           CONNECT BY BASE_MON + LEVEL - 1 <= LAST_DAY (BASE_MON) )
  GROUP BY WEEK_GRP
  ORDER BY WEEK_GRP

'DATABASE' 카테고리의 다른 글

[Oracle] 중복된 ROW데이터 삭제  (2) 2016.01.26
[Oracle] 테이블스페이스 관리 명령어  (0) 2013.12.02
[Oracle] 유저삭제  (0) 2013.12.02
[Oracle] 계정관련 명령어  (0) 2013.12.02
[Oracle] 해당 테이블 사용량  (0) 2013.11.29
공지사항
최근에 올라온 글
최근에 달린 댓글
Total
Today
Yesterday
링크
TAG
more
«   2024/05   »
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
글 보관함