Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> What's wrong with this statement? (7.3.4.5.0)

What's wrong with this statement? (7.3.4.5.0)

From: Not a valid email address <abuse_at_earthlink.net>
Date: Fri, 4 Feb 2000 18:58:31 -0500
Message-ID: <s9mpv9epdh15@corp.supernews.com>


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 04 2000 - 17:58:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US