Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: sql question

Re: sql question

From: Kevin Lidh <kevin.lidh_at_gmail.com>
Date: Thu, 20 Apr 2006 23:44:23 -0600
Message-ID: <cb4807f0604202244u187c2f96vb7f5ff4120205677@mail.gmail.com>


Okay, that one made me laugh.

On 4/20/06, Mladen Gogala <gogala_at_sbcglobal.net> 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
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
>
> --
> Mladen Gogala
> http://www.mgogala.com
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Apr 21 2006 - 00:44:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US