01
select max(decode(dow, 1, d, null)) Sun,
02
max(decode(dow, 2, d, null)) Mon,
03
max(decode(dow, 3, d, null)) Tue,
04
max(decode(dow, 4, d, null)) Wed,
05
max(decode(dow, 5, d, null)) Thu,
06
max(decode(dow, 6, d, null)) Fri,
07
max(decode(dow, 7, d, null)) Sat
08
from (select rownum d, www.2cto.com
09
rownum - 2 +
10
to_number(to_char(trunc(sysdate, 'MM'), 'D')) p,
11
to_char(trunc(sysdate, 'MM') -1 + rownum, 'D') dow
12
from all_objects
13
where rownum <=
14
to_number(to_char(last_day(to_date(sysdate)), 'DD')))
15
group by trunc(p / 7)