SELECT MIN(DECODE(week,'1',day)) SUN,
MIN(DECODE(week,'2',day)) MON,
MIN(DECODE(week,'3',day)) TUE,
MIN(DECODE(week,'4',day)) WED,
MIN(DECODE(week,'5',day)) THU,
MIN(DECODE(week,'6',day)) FRI,
MIN(DECODE(week,'7',day)) SAT
FROM (
SELECT LEVEL day, to_char(to_date('200905','YYYYMM')+LEVEL-1,'D') week
FROM DUAL
CONNECT BY LEVEL <= to_char(last_day(to_date('200905','YYYYMM')),'DD')
)
GROUP BY day +7 - week
ORDER BY 7