通过SQL来伪造两个日期之间的年份数据

通过SQL来伪造两个日期间的年份，作用和伪造月数据一样

WITH PARAMS AS(

  SELECT '2010-01-01' BG,'2014-12-31' ED FROM DUAL
),
YQ AS(
SELECT  ROWNUM+TO_NUMBER(SUBSTR(PM.BG,0,4))-1 YEAR
      FROM DUAL INNER JOIN PARAMS PM ON 1=1
      CONNECT BY ROWNUM<=((TO_NUMBER(SUBSTR((SELECT ED FROM PARAMS),0,4))-TO_NUMBER(SUBSTR((SELECT BG FROM PARAMS),0,4)))+1)
      ORDER BY YEAR                   
) 

SELECT * FROM YQ                  

截图如下: