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

Which version of Oracle do you use?

It should work in 8.1.5 and above.

Martin

Not a valid email address wrote:
>
> 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.
Received on Fri Feb 11 2000 - 12:14:58 CST