Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> What's wrong with this statement? (7.3.4.5.0)
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:
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 04 2000 - 17:58:31 CST