출처 : http://www.oracleclub.com/article/22424
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 )) wen
,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( '200912', 'YYYYMM') ym from dual)
connect by level <= LAST_DAY (ym) - ym + 1
group by trunc(ym + level, 'iw')
order by sat );
'IT Info > [Database]' 카테고리의 다른 글
[Oracle] HINT : Parallel Execution (1) | 2010.02.18 |
---|---|
[Oracle] Hint : INDEX_COMBINE (0) | 2009.12.21 |
[Oracle] Tip : 질의를 실행시킬 때 경과시간 측정하는 법.. (0) | 2009.12.18 |
[Oracle] Hint : INDEX_ASC, INDEX_DESC 힌트를 이용해서 MAX, MIN 값 구현하기. (0) | 2009.12.18 |
[Oracle] 한글화된 오라클 제품, 그 이면의 비밀 (0) | 2009.12.15 |