Re: sql question

  • From: "Jared Still" <jkstill@xxxxxxxxx>
  • To: rshamsud@xxxxxxxxxxxx
  • Date: Fri, 5 May 2006 09:31:17 -0700

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:

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