oracle写个日历（转）

select month, 
       min(decode(weekday,1,day)) "日",
       min(decode(weekday,2,day)) "一",
       min(decode(weekday,3,day)) "二",
       min(decode(weekday,4,day)) "三", 
       min(decode(weekday,5,day)) "四",
       min(decode(weekday,6,day)) "五",
       min(decode(weekday,7,day)) "六"
  from (     
           SELECT a.day,to_char(day,'yyyyMM') month,decode(sign(rn-weekday),1,week+1,week) week,weekday
             FROM (select day,
                          to_char(day, 'mm') month,
                          to_char(day, 'w') week, --周第
                          to_char(day, 'd') weekday,  --礼拜几
                          row_number() over(partition by to_char(day, 'mm'), to_char(day, 'w') order by day) rn --安照month和week排个序
                     from (select trunc(sysdate, 'yyyy') + level - 1 day  --今年全部年月日
                             from dual  
                           connect by rownum <= trunc(sysdate+365,'yyyy')-trunc(sysdate,'yyyy'))
                   ) a  )
 GROUP BY month,week
 ORDER BY month,week;