| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Create view with Order By
Neil Moseley wrote:
>
> 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/
You can use a "group by" in a view - but note that this is an approximation only - it it may be sorted, it may not be...
In 8i, you will be able to have order-by inline --
 |
 |