Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

Query dba_objects table group by object_type

SQL> SQL> SQL> select object_type, count(*)   2  from dba_objects   3  where rownum < 50   4  group by object_type   5  / OBJECT_TYPE            COUNT(*) -------------------- ---------- TABLE                        19 INDEX                        25 CLUSTER                       5 3 rows selected. SQL> --