Re: sql question

  • From: "Glenn Santa Cruz" <glenn.santacruz@xxxxxxxxx>
  • To: jkstill@xxxxxxxxx
  • Date: Fri, 5 May 2006 12:04:53 -0500

With slight modification, will work in 9i (dunno about 8):

select 1995+n from
(select level-1 n
   from dual,
        (select to_number(to_char(sysdate,'YYYY'))-1995+1 x from dual)
connect by level <= x )
/

Glenn

On 5/5/06, Jared Still <jkstill@xxxxxxxxx> wrote: 
Nice, but works only in 10g+


On 4/20/06, Riyaj Shamsudeen <rshamsud@xxxxxxxxxxxx> wrote:
>
> or this  ;-)
>
> select 1995+n from
>  (select level-1 n from dual connect by level <=
>         (select to_number(to_char(sysdate,'YYYY'))-1995+1
from dual ) )
> /
>
>

--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
//www.freelists.org/webpage/oracle-l


Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 05-2006