How can I get all the triggers linked to a specific table?

Question

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?

Solution

SELECT * FROM USER_TRIGGERS WHERE TABLE_NAME = 'NAME_OF_YOUR_TABLE';

Comments

[Peter Lang]

What do you mean by an action linked to a specific table? Do you want to find triggers that listen to changes of a certain table, or triggers on other tables, that modify some table?

[René Nyffenegger]

You might want to use ALL_TRIGGERS instead of USER_TRIGGERS if you are interested in schemas others than your own.