urgent : Need SQL help

[ora_inf]

Thanks for reply..

But, I want total count for distinct object_type...
e.g.
I want object_name,object_type for table then Total No. of table after that object_name,object_type for index then total No. of Indexes..

Thanks