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

User · Answer

Use the Oracle documentation and search for keyword  trigger  in your browser   This approach should work with other metadata type questions

User · Answer

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

User · Answer

Check out ALL TRIGGERS   http   download oracle com docs cd B19306 01 server 102 b14237 statviews 2107 htm i1592586

User · Answer

Another table that is useful is   SELECT   FROM user objects WHERE object type  TRIGGER     You can also use this to query views  indexes etc etc

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

Examples related to sql

Examples related to oracle