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.