Re: order by in VIEWs

From: Jurij Modic <jmodic_at_src.si>
Date: Thu, 19 Aug 1999 07:24:39 GMT
Message-ID: <37bbb0bb.1577437@news.siol.net>

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 Received on Thu Aug 19 1999 - 02:24:39 CDT