Get information on all the triggers you have access to using all_triggers. : all_triggers « System Tables Data Dictionary « Oracle PL/SQL Tutorial






SQL>
SQL> desc all_triggers;
 Name                  Null?    Type
 ----------------------

 OWNER                          VARCHAR2(30)
 TRIGGER_NAME                   VARCHAR2(30)
 TRIGGER_TYPE                   VARCHAR2(16)
 TRIGGERING_EVENT               VARCHAR2(227)
 TABLE_OWNER                    VARCHAR2(30)
 BASE_OBJECT_TYPE               VARCHAR2(16)
 TABLE_NAME                     VARCHAR2(30)
 COLUMN_NAME                    VARCHAR2(4000)
 REFERENCING_NAMES              VARCHAR2(128)
 WHEN_CLAUSE                    VARCHAR2(4000)
 STATUS                         VARCHAR2(8)
 DESCRIPTION                    VARCHAR2(4000)
 ACTION_TYPE                    VARCHAR2(11)
 TRIGGER_BODY                   LONG

SQL>
SQL> --select * from all_triggers;








30.19.all_triggers
30.19.1.Get information on all the triggers you have access to using all_triggers.