Name Value
OWNER AREL
TRIGGER_NAME DEL_MD_TRIGGERS_V_TRG
TRIGGER_TYPE AFTER EACH ROW
TRIGGERING_EVENT DELETE
TABLE_OWNER AREL
BASE_OBJECT_TYPE TABLE
TABLE_NAME MD_VIEWS
COLUMN_NAME null
REFERENCING_NAMES REFERENCING NEW AS NEW OLD AS OLD
WHEN_CLAUSE null
STATUS ENABLED
DESCRIPTION "DEL_MD_TRIGGERS_V_TRG" AFTER DELETE ON MD_VIEWS 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 = 'V'; END;
CREATED 2011-09-19 12:29:35.0
LAST_DDL_TIME 2011-09-19 12:29:35.0