티스토리 뷰
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 |