SQL中取得传入月份值的所有天数

清华大佬耗费三个月吐血整理的几百G的资源,免费分享!....>>>

select lpad(rownum, 2, 0) ymd
  from dual
connect by rownum <=
           (SELECT add_months(trunc(to_date('201002', 'yyyymm'), 'mm'), 1) -
                   trunc(to_date('201002', 'yyyymm'), 'mm')
              FROM DUAL)