Re: sql question

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_at_gmail.com> wrote:
> Nice, but works only in 10g+
>
>
> On 4/20/06, Riyaj Shamsudeen <rshamsud_at_jcpenney.com> 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
>

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