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 -> Sorting Using ORDER BY CLAUSE

Sorting Using ORDER BY CLAUSE

From: HTrieu <htrieu_at_aol.com>
Date: 1998/02/04
Message-ID: <19980204210801.QAA22345@ladder03.news.aol.com>#1/1

I want to create a pl-sql report ordering output from dba_segments by number of extents...I have 3 tables in one tablespace that have 100 extents and the order by clause is sorting these incorrectly. IE if there are 6 tables as follows:

tab1 3
tab2 5
tab3 8
tab4 101
tab5 9
tab6 88

The output of the order by clause is

tab5 9
tab3 8
tab6 88
tab2 5
tab1 3
tab4 101

HELP and thanks! Received on Wed Feb 04 1998 - 00:00:00 CST

Original text of this message

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