Last post Feb 21, 2011 12:02 PM by Shuvo Aymon
Feb 21, 2011 10:13 AM|pusnsuresh|LINK
I have a view in oracle database. I would like to know where exactly view has been used?
In which SP, Packages it is been used?
Please give me a query in Oracle?
Feb 21, 2011 12:02 PM|Shuvo Aymon|LINK
if you want to search with only procedures use below query
select * from user_source where type = 'PROCEDURE' and text like '%yourviewname%'
or for all package type.
select * from user_source where text like '%yourviewname%'