最近10年年份:
select TO_CHAR(Sysdate, 'YYYY') - level + 1 years from dual connect by level <= 10
拓展--最近10天日期时间:
select Sysdate - level + 1 years from dual connect by level <= 10
最近10年年份:
select TO_CHAR(Sysdate, 'YYYY') - level + 1 years from dual connect by level <= 10
拓展--最近10天日期时间:
select Sysdate - level + 1 years from dual connect by level <= 10