如何查找orcle中与某个表相关的存储过程

2025-03-22 21:44:36

推荐回答（4个）

回答1：

可以导出存储过程脚本在一个查询窗口里然后搜索某个表

回答2：

替换owner和object_name的条件（只能查一级引用）：

SELECT A.OBJECT_NAME
FROM DBA_OBJECTS A,public_dependency DEP,DBA_OBJECTS B
WHERE A.OBJECT_ID = DEP.OBJECT_ID AND DEP.REFERENCED_OBJECT_ID = B.OBJECT_ID
AND B.OWNER = 'XXXXXX'
AND B.OBJECT_TYPE = 'TABLE'
AND B.OBJECT_NAME = 'YYYYYYY'
AND A.OBJECT_TYPE IN ('FUNCTION','PROCEDURE')

回答3：

select a.* from sysobjects a, syscomments b where a.id = b.id and b.text like '%tablename%'
包含tablename这个表的存储过程

回答4：

窗体搜索表