Re: ORDER BY in View's subquery

On Wed, 19 Jan 2005 13:04:29 +0800, <tncc> wrote:

>The student guide for Introduction to Oracle9i: SQL mentioned that "the
>subquery that defines the view cannot contain an ORDER BY clause" (chap
>11-8). But I tested this with 9iR2 and the ORDER BY is allowed?! Is this
>just a difference between 9iR1 and 9iR2? Or is there something I am missing
>and a view's query really cannot have an ORDER BY ?
>
>Thx for any advice
>

You may want to check the release notes for 9ir2. If it is a new feature, it will have been documented.
IMO, they shouldn't have done this. A set is by design unordered.

--
Sybrand Bakker, Senior Oracle DBA