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: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Thu, 20 Apr 2006 23:59:52 -0400
Message-Id: <1145591992l.5146l.1l@medo.noip.com> 





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


Received on Thu Apr 20 2006 - 22:59:52 CDT












Original text of this message













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