--把'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' ) + LEVEL - 1 FROM DUAL CONNECT BY LEVEL <= SUBSTR(last_day(TO_CHAR(SYSDATE, 'yyyy-mm-dd')), -2, 2)
select trunc(sysdate,'mm')+rownum -1 from dual connect by rownum <= to_char(last_day(sysdate),'dd')
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);
FROM DUAL
CONNECT BY LEVEL <= SUBSTR(last_day(TO_CHAR(SYSDATE, 'yyyy-mm-dd')), -2, 2)
connect by rownum <= to_char(last_day(sysdate),'dd')