Re: order by in VIEWs

From: Nandakumar <nanban_at_my-deja.com>
Date: Thu, 19 Aug 1999 15:28:48 GMT
Message-ID: <7ph7r0$ht$1@nnrp1.deja.com>

How is Oracle 8i different from Enterprise Edition? I would like to know about materialized views. like how this is different from other oracle views. btw, what are these inline and explicit views?. If you could provide with some documents, study materials, that would be greatly appreciated.

Thanks
Nanda

In article <37bbb0bb.1577437_at_news.siol.net>, jmodic_at_src.si (Jurij Modic) wrote:
> On 18 Aug 1999 23:21:20 GMT, xux_at_informa.bio.caltech.edu (Xuequn Xu)
> wrote:
>
> >Why oracle doesn't allow "order by" in view definitions? It would be
such
> >a handy feature. Is it allowed in 8i, in the "materialized view"?
>
> Yes, ORDER BY inside a view is not allowed in any pre-8i release. In
> 8i you can use ORDER BY in any kind of views (explicit views, inline
> views).
>
> >Robert Xu
>
> HTH,
> Jurij Modic <jmodic_at_src.si>
> Certified Oracle DBA (7.3 & 8.0 OCP)
> ================================================
> The above opinions are mine and do not represent
> any official standpoints of my employer
>

--
Nandakumar
Systems Analyst
New York
(N.Kumar_at_rocketmail.com)

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Aug 19 1999 - 10:28:48 CDT