Re: A query in Oracle Report

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