Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

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

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;