Query dba_objects table group by object_type : dba_objects « System Tables Views « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Tables Views
  3. dba_objects

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> --








Related examples in the same category

1.Query object name by object id against dba_objects
2.list table, table partition, index, index partition and lob from dba_objects
3.List all not valid database objects
4.List all sys owned package name
5.Get all system packages