select wm_concat(to_char(a.aa, 'yyyy') + LEVEL -1) years
from (
select to_date('2018-01-01', 'yyyy-mm-dd') aa from dual) a
connect by level <= to_char(sysdate, 'yyyy') - to_char(a.aa, 'yyyy')+1
+level -1 表示2018向上取(2018,2019,2020...) -1 表示包含2018
-level +1 表示2018向下取(2018,2017,2016...) +1 表示包含2018