List of Oracle views using specific table name

oracle view find names

select     * from     all_dependencieswhere     type='VIEW'    and referenced_name like '%table_name%'    and referenced_type = 'TABLE'

oracle view find names

Use this query:

SELECT * FROM all_dependencies WHERE TYPE = 'VIEW'    AND referenced_type = 'TABLE'

CodeHunter