Find Oracle views using specific table

Sometimes you want to find all views using a specific database table in Oracle. If you are using a small amount of views, this is not an issue, but if you have a huge Oracle database with thousands of views using hundreds of tables you need help from your database.

In this case there is a handy small select statement which can be used to find all Oracle views using specific table in your database. It uses the “SYS.ALL_DEPENDENCIES” view which is provided by oracle.

select NAME 
  from SYS.ALL_DEPENDENCIES
where 
    type='VIEW'
    and REFERENCED_NAME like '%[YOUR_TABLE_NAME]%'
    and REFERENCED_TYPE = 'TABLE'

With this simple select statement you will get a list of all view names using your specific table.

Source:
https://stackoverflow.com/questions/21019584/list-of-oracle-views-using-specific-table-name/21020091