oracle显示一个月的所有天数

select to_date('200809','yyyymm')+(rownum-1) 

s_date from dual  

connect by rownum<=last_day(to_date('200809','yyyymm')) 

- to_date('200809','yyyymm')+1