Re: A query in Oracle Report

From: mo <m_at_m.com>
Date: Sun, 10 Oct 2004 01:45:40 +0800
Message-ID: <ck987o$ir41@imsp212.netvigator.com>

Developer/2000 - Reports 2.5.5.2.5C: Reports Runtime 2.5.5.2.5C

How can I solve it?

"Sybrand Bakker" <sybrandb_at_hccnet.nl> wrote in message news:6a6gm05vmrk3g1l5ik0cccpmnjv17j8jtr_at_4ax.com...
> On Sun, 10 Oct 2004 00:29:42 +0800, "mo" <m_at_m.com> wrote:
>
> >when I issue a query in Oracle Report:
> >
> >1. select * from
> >2. (
> >3. select first_name, last_name
> >4. from students
> >5. order by first_name
> >6. )
> >7. where rownum<3;
> >
> >I received a warning of missing a ")", if I
> >omit the 5th line, it's fine. should I use a cursor
> >to solve it?
> >
>
> No. You should specify your version in your post. Order by in inline
> views hasn't been supported always.
>
>
> --
> Sybrand Bakker, Senior Oracle DBA
Received on Sat Oct 09 2004 - 12:45:40 CDT