有表T_USER_TYPE,现在统计下用户a下面有多少存储过程里面用到了T_USER_TYPE表,如何搞? 有表T_USER_TYPE,现在统计下用户a下面有多少存储过程里面用到了T_USER_TYPE表。如何得到这些用到T_USER_TYPE表的存储过程的名字啊? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select NAME from ALL_DEPENDENCIES where REFERENCED_NAME ='T_USER_TYPE' SELECT DISTINCT NAME FROM DBA_SOURCE WHERE OWNER = 'a' AND TEXT LIKE '%T_USER_TYPE%' AND TYPE = 'PROCEDURE'; 如果你用的是PL/SQL这个工具的话,在tools中 find database objects就可以查询了 试试这个SQL> select name, type from dba_dependencies where referenced_name='T_USER_TYPE' and referenced_type='TABLE' and owner='a' and type='PROCEDURE'; --试试这个,需要DBA权限---select * from ALL_DEPENDENCIES where REFERENCED_NAME ='BST_SYS_SYSUSER' and type='PROCEDURE' and referenced_owner='ADD114' select name from all_dependencies where referenced_name = 'TB_USRPASSWD' and owner = 'CVBOM' and type = 'PROCEDURE'; 关于sql Loader问题 mfc使用oci连接数据详细步骤 触发器生成主键 未知表字段名的情况下,如何存储数据库中的数据 大侠!数据表很大 求一条SQL语句 如何写存储过程读取excel 的数据 为什么Oracle9i无法安装 存储过程的简单问题 asp与oracle的连接问题(高分相送) ORACLE解锁工具 表空间如何迁移?
FROM DBA_SOURCE
WHERE OWNER = 'a'
AND TEXT LIKE '%T_USER_TYPE%'
AND TYPE = 'PROCEDURE';
SQL> select name, type from dba_dependencies where referenced_name='T_USER_TYPE' and referenced_type='TABLE' and owner='a' and type='PROCEDURE';
select * from ALL_DEPENDENCIES where REFERENCED_NAME ='BST_SYS_SYSUSER' and type='PROCEDURE' and referenced_owner='ADD114'
select name
from all_dependencies
where referenced_name = 'TB_USRPASSWD'
and owner = 'CVBOM'
and type = 'PROCEDURE';