Re: Create view with Order By

Thanks for the response Chris, unfortunately, my particular client software does not permit access to the SQL, and simply returns all records in the view/table. I should have mentioned this in my original post.

Chris Hamilton wrote:

> On Tue, 13 Apr 1999 22:59:39 +0800, Neil Moseley <mose_at_iinet.net.au>
> wrote:
>
> >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.
>
> You have to order-by dynamically at run time.
>
> create view temp as select * from mytable;
>
> select * from temp order by mycolumn;
>
> Views do not store the data, nor the sort order - just the query.
>
> Chris
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Christopher Hamilton
> Oracle DBA -- Wall Street Sports
> chris_at_wallstreetsports.com
> http://www.wallstreetsports.com/
Received on Tue Apr 13 1999 - 18:16:18 CDT