WITH DATE_INFO AS (
SELECT '2011-01-01' START_DATE, '2014-01-01' END_DATE FROM DUAL --날짜범위
)
SELECT TO_CHAR(ADD_MONTHS(TO_DATE((SELECT START_DATE FROM DATE_INFO), 'YYYY-MM-DD'),level),'YYYY-MM') MONTHS
FROM DUAL
CONNECT BY LEVEL <= MONTHS_BETWEEN(TO_DATE((SELECT END_DATE FROM DATE_INFO), 'YYYY-MM-DD'), TO_DATE((SELECT START_DATE FROM DATE_INFO), 'YYYY-MM-DD'))
