Re: order by in VIEWs

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 19 Aug 1999 14:18:40 GMT
Message-ID: <37c11222.271262004@newshost.us.oracle.com>

A copy of this was sent to xux_at_informa.bio.caltech.edu (Xuequn Xu) (if that email address didn't require changing) On 18 Aug 1999 23:21:20 GMT, you 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"?
>
>Robert Xu

It is allowed in Oracle8i, release 8.1 with a regular view.

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Aug 19 1999 - 09:18:40 CDT