Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: sql question
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-lReceived on Fri May 05 2006 - 11:31:17 CDT