SQL中取得传入月份值的所有天数 2015/09/27 39298 清华大佬耗费三个月吐血整理的几百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)