Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »


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

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  

  • No labels