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

2015/09/27 13948 

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)

编程技巧