Search notes:

Oracle: DBA_CATALOG

dba_catalog has the names of

Select the number of objects for all four object types:

select
   count(*),
   table_type
from
   dba_catalog
group by
   table_type;

Select the names of the current user's tables and views:

select
   table_name
from
   user_catalog
where
   table_type in ('TABLE', 'VIEW')
order by
   table_name;

dba_catalog comes in all four varinats dba_catalog, all_catalog, user_catalog and cdb_catalog.

See also