CONSECUTIVE Values

SQL> select MIN(c_year), MAX(c_year)
  2 from T
  3 ;

MIN(C_YEAR)                 MAX(C_YEAR)


---------------------------  -----------------------------------------------

-

1996                                  2005

There may be gaps in this column value... How can I ensure to return a result of CONSECUTIVE values...like:

1996
1997
1998
1999
2000
2001
2002
2003
2004
2005

Thanks Received on Tue Nov 18 2003 - 14:30:36 CST