如何找出存储过程中使用了哪些表/视图/同义词 [英] How to find out what tables/views/synonyms are used in a stored procedure

问题描述

通过Oracle查询，可以发现存储过程使用哪些视图/同义词/表?

Through Oracle queries is it possible to find out which views/synonyms/tables a stored procedure use?

在PL/SQL Developer中，如果展开一个存储过程，它将显示参考"，该参考"显示该存储过程使用的所有表/视图/同义词.

In PL/SQL Developer if you collapse out a stored procedure it will show "References" which shows all the tables/views/synonyms that the stored procedure uses.

我正在尝试将此功能实现为一个方便使用的脚本.

I am trying to implement this functionality into a script which will come in handy.

想知道是否有人会使用脚本来获取存储过程使用的所有同义词/视图/表吗?

Wondering if anyone knows a script that will fetch me all the synonyms/views/tables that a stored procedure uses?

推荐答案

您要查找的信息位于user_dependencies/all_dependencies视图中.

The information you are looking for is in the user_dependencies/all_dependencies view.

这篇关于如何找出存储过程中使用了哪些表/视图/同义词的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！