Oracle 8.0.5.0.0 in-line view and Order By

From: <mike.allen_at_snowvalley.com>
Date: Thu, 05 Aug 1999 09:27:03 GMT
Message-ID: <7obld0$vb1$1@nnrp1.deja.com>

I've checked past postings and there appears to be a consensus on select *
from
(select * from conversations order by timeofdeal desc)
where rownum <= 200;
to equate to TOP 200 in Oracle 8.x
However, this produces the following in 8.0.5.0.0:

SQLWKS> select *
     2> from
     3> (select * from conversations order by timeofdeal desc)
     4> where rownum <=200
     5> ;


(select * from conversations order by timeofdeal desc)


                             *

ORA-00907: missing right parenthesis

Neither can I create a view in the Schema Manager that includes Order By

I also tried the TABLE(CAST(MULTISET(... suggestion (didn't work) and the GROUP BY method just seems a total hack. Is this supposed to work in Oracle 8.x, or have I misinterpreted past postings?

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Aug 05 1999 - 04:27:03 CDT