Clarity

 View Only
Expand all | Collapse all

Query to find View which is being used in Functions or Stored Procedures

  • 1.  Query to find View which is being used in Functions or Stored Procedures

    Posted Oct 04, 2016 08:01 AM

    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



  • 2.  Re: Query to find View which is being used in Functions or Stored Procedures

    Posted Oct 04, 2016 09:54 AM

    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.