SQL> select count(object_name), object_type from dba_objects group by object_type;
(or)
SQL> select count(object_name), object_type from all_objects where owner='LIMS_ADMIN' group by object_type;(finding schema vice).
(or)
SQL> select count(object_name), object_type from all_objects where owner='LIMS_ADMIN' group by object_type;(finding schema vice).
No comments:
Post a Comment