日期:2014-05-17 浏览次数:21020 次
--把'2012-12'换成你需要的月份即可
select to_date('2012-12','yyyy-mm')+rownum-1 from dual connect by rownum <=
(last_day(to_date('2012-12','yyyy-mm'))-to_date('2012-12','yyyy-mm')+1);
select trunc(sysdate,'mm')+rownum -1 from dual
connect by rownum <= to_char(last_day(sysdate),'dd')