Re: Order By Problem

Upgrade to Oracle 8i, which allows exactly what you want ...

"Shaojie Hu" <maichen_at_rols.com> wrote in message news:8605vb$hmn$1_at_bob.news.rcn.net...
> Hi, All:
>
> Oracle does not allow to use Order By clause in subquery, how do I solve
the
> problem?
> what I want is something like this:
>
> select * from (select x.*, rownum r from foo
> order by col1);
>
> Thanks.
>
>
Received on Mon Jan 17 2000 - 17:37:57 CST