oracle 如何获取链接到特定表的所有触发器？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/2817078/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How can I get all the triggers linked to a specific table?
提问by Tami
I'm searching for a way to retrieve all the triggers where there is an action linked to a specific table. I don't want to read manually all the triggers I have on the server as there are too many.
我正在寻找一种方法来检索所有触发器，其中有链接到特定表的操作。我不想手动读取服务器上的所有触发器，因为触发器太多了。
Any ideas?
有任何想法吗？
回答by UltraCommit
SELECT * FROM USER_TRIGGERS WHERE TABLE_NAME = 'NAME_OF_YOUR_TABLE';
回答by Jo Holvoet
If you mean what Peter Lang indicated then look into the view dba_dependencies (or all_dependencies or user_dependencies of course).
如果您指的是 Peter Lang 所指的内容，请查看视图 dba_dependencies（当然也可以是 all_dependencies 或 user_dependencies）。
