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