Hi

How can I get the following results? I am concern with how to get the total of distict object_type along with object_name and object_type.

OBJECT_NAME OBJECT_TYPE
------------------------------ ------------------
T1 TABLE
T2 TABLE
T3 TABLE
T4 TABLE
--------------
Total=4
I1 INDEX
I2 INDEX
-------------
Total=2

Following query gives me object_name and object_type but not total along with object_type and object_name..
select object_name,object_type
from user_objects
group by object_name,object_type
order by object_type

Thanks.