Re: sql question

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

Other related posts: