Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Sorting Using ORDER BY CLAUSE
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
![]() |
![]() |