Re: What's wrong with this statement? (7.3.4.5.0)

"Not a valid email address" <abuse_at_earthlink.net> writes:

> Any guesses why this statement works:
> SQL> select * from user_extents order by segment_name;
> ...
> 171 rows selected.
> but this fails:
> SQL> select * from (select * from user_extents order by segment_name);
> select * from (select * from user_extents order by segment_name)
> *
> ERROR at line 1:
> ORA-00907: missing right parenthesis
>
> What I really want is
> select * from (select * from user_extents order by segment_name) where
> rownum < 100;
> i.e. the first 99 extents or all the extents sorted by segment_name,
> but it doesn't like that either.
>
>
>

you can't have an ORDER By in an inline view.

--
The fundamental aim of King Crimson is to organize anarchy, to utilize

   the latent power of chaos and to allow the varying influences to

	       interact and find their own equilibrium.
                                        -Robert Fripp