SELECT REPORT_TIME
FROM (SELECT 200601 + ROWNUM -1 REPORT_TIME
FROM (SELECT *
FROM DUAL
CONNECT BY 1 = 1)
WHERE ROWNUM <= ('200703' - 200601) + 1)
WHERE MOD (REPORT_TIME, 100) IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12) 即输出:200601
200602
……
200612
200701
200702
200703
FROM (SELECT 200601 + ROWNUM -1 REPORT_TIME
FROM (SELECT *
FROM DUAL
CONNECT BY 1 = 1)
WHERE ROWNUM <= ('200703' - 200601) + 1)
WHERE MOD (REPORT_TIME, 100) IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12) 即输出:200601
200602
……
200612
200701
200702
200703
按照你的sql从里向外写就是