Re: order by in VIEWs

Because there is no need.
Why restrict the view ?
You can order by whatever you like when you select data from the view.

Xuequn Xu wrote in message <7pff5g$i7o_at_gap.cco.caltech.edu>...
>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
Received on Wed Aug 18 1999 - 20:19:31 CDT