Re: How do you order by rows in a view?

In article <D0wKyK.Hrx_at_nrigw11.nri.co.jp> y-tamura_at_nriws11.nri.co.jp (Youichi Tamura) writes:

> You can't use order by with a create view statement.
> So you're supposed to use group by instead. It works.
> What I want to do, however, is to sort the rows in a
> descending order, and, apparently, group by clause does
> not take [desc] parameter, as does order by.
>
> How else can you do it?

This may be a case of abuse, but what about using a hint to force a index scan on a descending order index?

--
      ___
     (o o)
+-oo0-\_/-0oo---------------------------------------------------------------+
| Alvin Law .. Project Leader, Applications Division ... Oracle Corporation |
|  Email: alaw_at_us.oracle.com ..... Voice: 415.506.8317 . Fax: 415.506.7299  |
+---------------------------------------------------------------------------+

ORA-03113: end-of-file on communication channel