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

来源:互联网 发布:网络暴力赚钱 编辑:程序博客网 时间:2024/05/01 04:36
1. 
select    *from    dba_dependencieswhere 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