Oracle PL/SQL Tutorial/System Tables Data Dictionary/DICTIONARY

List table name from 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>