-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|