Re: Create view with Order By

Just remember that Oracle does not guarantee that the groups will be in any specific order. Yes, today's Oracle sorts the rows to accomplish the grouping. Tomorrow, a better algorithm may be found.

Rudy Zung wrote:

> Neil Moseley wrote in message <37135BDB.73449C6_at_iinet.net.au>...
> >G'day all,
> >
> >This statement works fine:
> >SELECT * FROM MYTABLE ORDER BY MYCOLUMN;
> >But this does not:
> >CREATE VIEW TEMP AS SELECT * FROM MYTABLE ORDER BY MYCOLUMN;
> >
> >If ORDER BY cannot be used when creating a view, is there a solution.
> >
> >Thankyou
> >
> >Neil Moseley
>
> You can't have an ORDER BY in a view; but, I believe you can use
> a side-effect of GROUP BY to accomplish an implicit sort within
> your view.
>
> ...Ru
Received on Tue Apr 13 1999 - 22:46:10 CDT