RE: sql question

  • From: "Mercadante, Thomas F \(LABOR\)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
  • To: <kevin.lidh@xxxxxxxxx>, <gogala@xxxxxxxxxxxxx>
  • Date: Fri, 21 Apr 2006 08:21:23 -0400

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



 

Other related posts: