Oralce generate year data for the first n years

today to do a statistical report of the time just encountered this problem, the original, usually through the background code to generate. Now generate it directly from Oracle and record it.

Method One:SELECT  Year  from (  SELECTTo_char (sysdate-ROWNUM*365,'YYYY') Year  fromDUAL CONNECT byROWNUM< $  UNION  SELECTTo_char (Sysdate,'YYYY') Year  fromDUAL)ORDER  by    Year DESC; method Two:SELECT  Year  from (  SELECTTo_char (sysdate-ROWNUM*365,'YYYY') Year  fromDUAL CONNECT by  Level<Ten  UNION  SELECTTo_char (Sysdate,'YYYY') Year  fromDUAL)ORDER  by    Year DESC;

Oralce generate year data for the first n years