Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Rownum in Oracle 8.0.x
Hi,
i'm not quite sure,
but:
create or replace view xxx as
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;
select * from xxx where rownum=1
I think 8.0.x have no inline-views ( select * from (select * from ))
Hth
Thomas
c.hartmann_at_tmp-office.de (Christian Hartmann) wrote in message news:<3b83d04c.9503625_at_news.ewetel.net>...
> Hi there,
>
> this works propery in Oracle 8.1.x and higher:
>
create view
> 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
Received on Thu Aug 23 2001 - 09:21:17 CDT