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 |