create incremental number in oracle sql query
I think this will work (based on  this page ( http://psoug.org/definition/LEVEL.htm ) as a starting point):

WITH counter
AS ( SELECT LEVEL seq
       FROM DUAL
     CONNECT BY LEVEL &lt;= 4 )
SELECT (2008 + seq - 1) myYear
  FROM counter
 ORDER BY 1
;


This should return:

myYear
------
  2008
  2009
  2010
  2011


Adjust 2008 and 4 to get different results.