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