SELECT DISTINCT(TO_CHAR(T.ROWDATE, ‘yyyymm‘)) YYYYMM
FROM (
SELECT ROWNUM, TO_DATE(‘201805‘, ‘yyyymm‘) + ROWNUM - 1 ROWDATE
FROM DUAL CONNECT BY ROWNUM < TO_DATE(‘201901‘, ‘yyyymm‘) - TO_DATE(‘201805‘, ‘yyyymm‘) + 2) T
ORDER BY YYYYMM
原文：https://www.cnblogs.com/zhangzhiqin/p/13209884.html