oracle查看存储过程用到的表
SELECT name, type, referenced_owner, referenced_name, referenced_type
FROM user_dependencies
WHERE referenced_name = 'TABLENAME' AND
referenced_type='TABLE' AND
type = 'PROCEDURE';
oracle查看存储过程用到的表
SELECT name, type, referenced_owner, referenced_name, referenced_type
FROM user_dependencies
WHERE referenced_name = 'TABLENAME' AND
referenced_type='TABLE' AND
type = 'PROCEDURE';