Hello All,
I would like to find 2 Views which are actually being used in other Functions or Stored procedures(SP's) , as there are many Functions and SP's it takes much time if we go manually.Could you please suggest any alternate way or any Query which will list us Functions and SP's using Views which we want to check.
Regards,
Santosh
If it is Oracle, give below query a try.
select * from dba_source where lower(text) like '%<put your view name in lower case>%'
You may google to find more information about dba_source.