Re: Create view with Order By

Neil Moseley <mose_at_iinet.net.au> wrote in message news: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
>
>

In Oracle8i you can create views with an ORDER BY.

Finn Received on Sun Apr 25 1999 - 07:12:17 CDT