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?
>
> "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 Received on Sat Oct 09 2004 - 12:55:46 CDT