RE: sql question

From: Mercadante, Thomas F \(LABOR\) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Fri, 21 Apr 2006 08:21:23 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FF681165@EXCNYSM0A1AJ.nysemail.nyenet>

Me too. That Mladen. What a jokster.

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kevin Lidh Sent: Friday, April 21, 2006 1:44 AM
To: gogala_at_sbcglobal.net
Cc: cstephens16_at_gmail.com; oracle-l
Subject: Re: sql question

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 - 07:21:23 CDT