locked
View dependency query required RRS feed

  • Question

  • User-182690678 posted

    Hi,

    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?

    Thanks inAdvance

    Monday, February 21, 2011 10:13 AM

Answers

  • User-1412735316 posted

     

    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%'

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, February 21, 2011 12:02 PM