摘要:
1 阅读全文
摘要:
触发器:自动执行,可以实现表的约束。1.行级触发器: CREATE OR REPLACE TRIGGER del_deptidAFTER DELETE ON deptment --触发器条件 DELETE动作FOR EACH ROW --循环每一行都改BEGINDELETE FROM emp WHERE id=:old.id; --触发后动作END del_deptid; --END;都行/ DELETE FROM deptment WHERE id='001'; --触发触发器CREATE OR REPLACE... 阅读全文