Re: Can we use ORDER BY in view?

Mark D Powell wrote:

> What version of whose student guide do you have? Order by clauses in
> views were not supported back in version 7, but this restriction has
> been lifted. I do not remember the exact version when Oracle lifted
> this restriction; it may have been with one of the 8.1 versions.
> However, order by clauses should appear in views only where necessary
> to create the correct result set. In the majority of cases the final
> set ordering should be specified with the query on the view.
>
> Someone else might remember the version where this changed but with 9.2
> it is legal.
>
> HTH -- Mark D Powell --

At issue here is Couchman's book. Couchman may know Oracle but his editors didn't do him a service when they took his 8i book and tried to relabel it as 9i.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)