oracle 生成递增年份 脚本:SELECT (to_number(to_char(SYSDate, ‘YYYY’)) - 20 + ROWNUM) AS ny FROM DUAL CONNECT BY ROWNUM <= 82 order by ny 执行结果图: