Me too. That Mladen. What a jokster. ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Kevin Lidh Sent: Friday, April 21, 2006 1:44 AM To: gogala@xxxxxxxxxxxxx Cc: cstephens16@xxxxxxxxx; oracle-l Subject: Re: sql question Okay, that one made me laugh. On 4/20/06, Mladen Gogala <gogala@xxxxxxxxxxxxx> wrote: select '1995, 1996, 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006' from dual; On 04/20/2006 04:40:44 PM, Chris Stephens wrote: > Can anyone think of a way to generate a list of years from say 1995 to > the current year in straight sql? > > > chris > -- > //www.freelists.org/webpage/oracle-l > > > -- Mladen Gogala http://www.mgogala.com -- //www.freelists.org/webpage/oracle-l