Re: A query in Oracle Report

Oracle Applications

¡P Forms Runtime 4.5.7.1.8

¡P Oracle Installer 3.1.4.1.3

¡P SQL*Net Client 2.3.2.1.7

¡P SQL*Plus 3.2.2.0.2

¡P Application Object Library Runtime 7.5.16.0.2 <--------

¡P Common Financials Runtime 1.1.10.1.2

¡P Oracle Alert Runtime 5.5.27.0.2

¡P Oracle General Ledger Runtime Modules 9.0.10.1.2

¡P Oracle Payables Runtime 8.5.11.0.2

¡P Oracle Purchasing Runtime 9.0.11.0.2

Oracle Receivables Runtime 7.5.10.0.2

"Dave" <david.sharples3_at_ntlXworld.com> wrote in message news:CCV9d.338$Kb7.307_at_newsfe3-win.ntli.net...

>
> "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?
> >
> > "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
> >
> >
>
> Which oracle version is the key thing here
>
>