当前位置:操作系统 > Unix/Linux >>

How to search a table in a store proc and open the store proc

How to search a table in a store proc and open the store proc
 
1. 
select 
   *
from 
   dba_dependencies

where referenced_name='CNTL_ISSUE'

and TYPE='PROCEDURE'

2. 
select text from all_source where name = 'SP_ARA_TEMPALTE_UPLOAD' and type = 'PROCEDURE' order by line

 


CopyRight © 2022 站长资源库 编程知识问答 zzzyk.com All Rights Reserved
部分文章来自网络,