查询时间范围内对应的年
SELECT
TO_CHAR (
ADD_MONTHS (
TO_DATE ('2013', 'yyyy'),
(ROWNUM - 1) * 12
),
'yyyy'
) AS years
FROM
DUAL CONNECT BY ROWNUM <= MONTHS_BETWEEN (
TO_DATE ('2018', 'yyyy'),
TO_DATE ('2013', 'yyyy')
) / 12 + 1