Re: Rownum in Oracle 8.0.x

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 22 Aug 2001 18:54:44 +0200
Message-ID: <to7oungtu3opb7@news.demon.nl>

"Christian Hartmann" <c.hartmann_at_tmp-office.de> wrote in message news:3b83d04c.9503625_at_news.ewetel.net...
> Hi there,
>
> this works propery in Oracle 8.1.x and higher:
>
> select * from
> (select eur_kurs
> from waehrung
> where c_waehrung='USD'
> and i_firm_refid=:i_firm_refid
> and d_tag<=:d_tag
> order by d_tag desc)
> where rownum=1
>
> Unfortunately it doesn't work within an Oralce 8.0.x :-(
>
> Is there a workaround?
>
>
> Mfg,
>
> Christian Hartmann
> .tmp Informationssysteme GmbH & Co. KG
> Oracle Certified Solution Partner
> Roonstrasse 1, D-26122 Oldenburg
> Germany
> Tel.: +49-441-983983
> Fax: +49-441-9839878
> http://www.tmp-office.de

Sure,
upgrade the 8.0 database to 8i (8.0 will be history on October 1, so you need to do it anyway).
You are using a 8i new feature, so there's no way to get it working in 8.0

Regards,

Sybrand Bakker,
Senior Oracle DBA Received on Wed Aug 22 2001 - 11:54:44 CDT