Mega Code Archive
List table name from dictionary
<![CDATA[
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>
]]>