Re: Create view with Order By

From: Chris Hamilton <ToneCzar_at_erols.com>
Date: Tue, 13 Apr 1999 16:14:32 GMT
Message-ID: <37136d1f.16853113@news.erols.com>

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 - 11:14:32 CDT