group by clause didn't work
I recently installed a 9i database, however, I have noticed my group by clause didn't work right by some strange reasons.
SQL> l
1 select owner,object_type,count(*) from
2* dba_objects group by owner,object_type
OWNER OBJECT_TYPE COUNT(*)
------------------------------ ------------------ ----------
RAM SYNONYM 51
SYS LOB 28
SYS TYPE 465
SYS VIEW 2087
SYS INDEX 311
SYS QUEUE 4
SYS TABLE 341
SYS CLUSTER 10
SYS CONTEXT 1
SYS LIBRARY 62
SYS PACKAGE 342
OWNER OBJECT_TYPE COUNT(*)
------------------------------ ------------------ ----------
SYS SYNONYM 6
SYS TRIGGER 10
SYS FUNCTION 41
SYS OPERATOR 1
SYS SEQUENCE 41
SYS JAVA DATA 293
SYS PROCEDURE 25
SYS TYPE BODY 23
SYS JAVA CLASS 8789
SYS JAVA SOURCE 8
SYS PACKAGE BODY 318
OWNER OBJECT_TYPE COUNT(*)
------------------------------ ------------------ ----------
SYS JAVA RESOURCE 173
SYS RESOURCE PLAN 3
SYS CONSUMER GROUP 4
SYS EVALUATION CONTEXT 1
HIEN TABLE 4
HIEN SYNONYM 51
Clarification - the order of records is wrong
Just for a clarification, what I mean is that the sort order of records is wrong.