Sunday, 5 February 2023

Objects in the database.

 select owner,object-type,count(*) from dba_objects where owner not in (select username from dba_users where oracle_maintained='Y') group by owner,object_type order by 1;

select owner,object_type,count(*) from dba_objects where owner in ('HR') group by owner,object_type order by 1;

No comments:

Post a Comment