Name Value
OWNER AREL
TRIGGER_NAME DEL_MD_TRIGGERS_T_TRG
TRIGGER_TYPE AFTER EACH ROW
TRIGGERING_EVENT DELETE
TABLE_OWNER AREL
BASE_OBJECT_TYPE TABLE
TABLE_NAME MD_TABLES
COLUMN_NAME null
REFERENCING_NAMES REFERENCING NEW AS NEW OLD AS OLD
WHEN_CLAUSE null
STATUS ENABLED
DESCRIPTION "DEL_MD_TRIGGERS_T_TRG" AFTER DELETE ON MD_TABLES FOR EACH ROW
ACTION_TYPE PL/SQL
TRIGGER_BODY BEGIN DELETE FROM MD_TRIGGERS WHERE MD_TRIGGERS.TABLE_OR_VIEW_ID_FK = :OLD.ID AND MD_TRIGGERS.TRIGGER_ON_FLAG = 'T'; END;
CREATED 2011-09-19 12:29:35.0
LAST_DDL_TIME 2011-09-19 12:29:35.0