Re: A query in Oracle Report

"mo" <m_at_m.com> wrote in message news:<ck987o$ir41_at_imsp212.netvigator.com>...
> Developer/2000 - Reports 2.5.5.2.5C: Reports Runtime 2.5.5.2.5C
>
> How can I solve it?
>

Upgrade to Report 6i. Seriously, Report 2.5 does it's own SQL statement parsing first, and it doesn't understand ORDER BY within inline views (I'm not even sure it understands inline views, didn't work with it for years).

> "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 Tue Oct 12 2004 - 11:35:29 CDT