ORACLE获取某个时间段之间的月份列表
SELECT TO_CHAR(ADD_MONTHS(TO_DATE('2009-03','YYYY-MM'),ROWNUM-1 ),'YYYY-MM') DAY_ID FROM DUAL CONNECT BY ROWNUM<=months_between (to_date('2010-03', 'yyyy-mm'),to_date('2009-03', 'yyyy-mm'))+1