SELECT TO_CHAR(ADD_MONTHS(TO_DATE('2009-03','yyyy-mm'),RN),'yyyy-mm') DTM
FROM
(
SELECT ROWNUM-1 AS RN FROM TB_METAP00
WHERE ROWNUM-1 <= MONTHS_BETWEEN(TO_DATE('2009-12', 'yyyy-mm'),TO_DATE('2009-03', 'yyyy-mm'))
);
FROM
(
SELECT ROWNUM-1 AS RN FROM TB_METAP00
WHERE ROWNUM-1 <= MONTHS_BETWEEN(TO_DATE('2009-12', 'yyyy-mm'),TO_DATE('2009-03', 'yyyy-mm'))
);