List table name from dictionary : DICTIONARY « System Tables Data Dictionary « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Tables Data Dictionary
3. DICTIONARY

SQL>
SQL>
SQL> COLUMN      table_name FORMAT a20
SQL> COLUMN      comments FORMAT a55
SQL> SELECT      *
  2  FROM        DICTIONARY
  3  WHERE       table_name LIKE '%DEPEND%'
  4  and         rownum < 50;

TABLE_NAME           COMMENTS
-------------------- -------------------------------------------------------
ALL_REFRESH_DEPENDEN Description of the detail tables that materialized view
CIES                 s depend on for
                     refresh

USER_DEPENDENCIES    Dependencies to and from a users objects
ALL_DEPENDENCIES     Dependencies to and from objects accessible to the user
DBA_DEPENDENCIES     Dependencies to and from objects
V$OBJECT_DEPENDENCY  Synonym for V_$OBJECT_DEPENDENCY
GV$OBJECT_DEPENDENCY Synonym for GV_$OBJECT_DEPENDENCY
DBA_APPLY_VALUE_DEPE Synonym for _DBA_APPLY_CONSTRAINT_COLUMNS
NDENCIES

TABLE_NAME           COMMENTS
-------------------- -------------------------------------------------------

DBA_APPLY_OBJECT_DEP Synonym for _DBA_APPLY_OBJECT_CONSTRAINTS
ENDENCIES


8 rows selected.

SQL>