Re: Oracle 8.0.5.0.0 in-line view and Order By

ORDER BY in in-line views is a feature of 8.1, not 8.0

The syntax TABLE(.... is also 8.1, but this is just a minor detail, the 8.0 version is THE(.....)

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

mike.allen_at_snowvalley.com wrote in message <7obld0$vb1$1_at_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:57:15 CDT