Oracle 根据表名查询涉及的存储过程

• 方式1

  SELECT * FROM USER_DEPENDENCIES WHERE REFERENCED_NAME = '表名'
  

• 方式2

  SELECT DISTINCT NAME FROM USER_SOURCE WHERE TYPE = 'PROCEDURE' AND UPPER(TEXT) LIKE '%表名%'