Re: Order By Problem

From: Shaojie Hu <maichen_at_rols.com>
Date: Mon, 17 Jan 2000 19:06:27 -0600
Message-ID: <860alr$g6b$1@bob.news.rcn.net>

I am using Oracle8 not Oracle8i because we use other technologies for intenet
instead of Oracle8i.

Thanks.

Bert Scalzo <bscalzo_at_home.com> wrote in message news:pJNg4.3039$k25.309392_at_news1.rdc2.tx.home.com...
> 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 - 19:06:27 CST