Re: sql question
- From: "Chris Stephens" <cstephens16@xxxxxxxxx>
- To: "Mladen Gogala" <gogala@xxxxxxxxxxxxx>
- Date: Fri, 21 Apr 2006 08:53:30 -0400
yeah...that works this year. the whole point is to not have to
maintain a list of years up to the current year to infinity and
beyond.
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
Other related posts:
