Oracle: SQL query to find all the triggers belonging to the tables?

Question

how can i find all the triggers that belong to a table?

Answer 1

The following will work independent of your database privileges:

select * from all_triggers where table_name = 'YOUR_TABLE' 

The following alternate options may or may not work depending on your assigned database privileges:

select * from DBA_TRIGGERS 

or

select * from USER_TRIGGERS