oracle中的trigger

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 --创建表CREATE? TABLE? employee(??id? VARCHAR2(4) NOT? NULL,??name? VARCHAR2(15) NOT? NULL,??age NUMBER(2)? NOT? NULL,??sex CHAR? NOT? NULL);--插入数据INSERT? INTO? employee VALUES(‘e101‘,23,‘M‘);INSERT? INTO? employee VALUES(‘e102‘,‘jian‘,21,‘F‘);--创建记录表(包含数据记录)CREATE? TABLE? old_employee AS? SELECT? * FROM? employee;--创建触发器CREATE? OR? REPLACE? TRIGGER? TIG_OLD_EMP?AFTER? DELETE? ON? EMPLOYEE?FOR? EACH ROW --语句级触发，即每一行触发一次BEGIN?INSERT? INTO? OLD_EMPLOYEE VALUES? (:OLD.ID,:OLD.NAME,:OLD.AGE,:OLD.SEX); --:old代表旧值END;/--下面进行测试DELETE? employee;SELECT? * FROM? old_employee;

（编辑：好传媒网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!

4)、创建触发器，用来记录表的删除数据