简简单单三步走,带你解决问题
1.创建日期表,包含你要用的年和月
SELECT TO_CHAR(ADD_MONTHS(TO_DATE('2005-01', 'yyyy-mm'), ROWNUM - 1),'yyyy') AS calcmonthlist,
TO_CHAR(ADD_MONTHS(TO_DATE('2005-01', 'yyyy-mm'), ROWNUM - 1),'mm') AS monthlist
FROM DUAL
CONNECT BY ROWNUM <=months_between(to_date('200712', 'yyyyMM'),to_date('200501', 'yyyyMM')