Oracle根据表名查询过程名

一、根据sql查询

SELECT NAME, TYPE, REFERENCED_OWNER, REFERENCED_NAME, REFERENCED_TYPE
  FROM USER_DEPENDENCIES
 WHERE REFERENCED_NAME = UPPER('表名')
   AND TYPE = 'PROCEDURE';

--或者这种方法
SELECT DISTINCT NAME
  FROM USER_SOURCE
 WHERE TYPE = 'PROCEDURE'
   AND UPPER(TEXT) LIKE UPPER('%insert into 表名%');

二、用plsql developer工具进行查询

1、点击objects中头部望远镜

2、输入要查询的文本以及添加查询条件

转载于:https://www.cnblogs.com/ViokingJava/p/8184973.html