We're here to help!

list_all_triggers.txt

Follow


This file contains the output of the Oracle Data Dictionary view DBA_TRIGGERS.  This information may useful when looking into why conflicts happen.


Sample file:

List of triggers
select OWNER, TRIGGER_NAME, TRIGGER_TYPE, TRIGGERING_EVENT, TABLE_OWNER, BASE_OBJECT_TYPE, TABLE_NAME, COLUMN_NAME, REFERENCING_NAMES, WHEN_CLAUSE, STATUS, ACTION_TYPE from dba_triggers order by 1, 2, 3 


TEST1	TRIGGER_TABLE7_D	AFTER EACH ROW	DELETE	TEST1	TABLE	TABLE7		REFERENCING NEW AS NEW OLD AS OLD		ENABLED	PL/SQL     
TEST1	TRIGGER_TABLE7_I	AFTER EACH ROW	INSERT	TEST1	TABLE	TABLE7		REFERENCING NEW AS NEW OLD AS OLD		ENABLED	PL/SQL     
TEST1	TRIGGER_TABLE7_U	AFTER EACH ROW	UPDATE	TEST1	TABLE	TABLE7		REFERENCING NEW AS NEW OLD AS OLD		ENABLED	PL/SQL     
TEST1	TRIGGER_TABLE8_D	AFTER EACH ROW	DELETE	TEST1	TABLE	TABLE8		REFERENCING NEW AS NEW OLD AS OLD		ENABLED	PL/SQL     
TEST1	TRIGGER_TABLE8_I	AFTER EACH ROW	INSERT	TEST1	TABLE	TABLE8		REFERENCING NEW AS NEW OLD AS OLD		ENABLED	PL/SQL     
TEST1	TRIGGER_TABLE8_U	AFTER EACH ROW	UPDATE	TEST1	TABLE	TABLE8		REFERENCING NEW AS NEW OLD AS OLD		ENABLED	PL/SQL  

Have more questions? Submit a request

Comments