CREATE OR REPLACE TRIGGER trigger_insert_appraise
BEFORE UPDATE ON t_appointment
FOR EACH ROW
/**
* 注:对同一张表操作的话不应该用after update,而应该是before update ,
* 就是应该在update之前进行更改,而且这是update哪条数据就对那条数据进行修改
*/
DECLARE
vs_appraise_id varchar(11);
BEGIN
IF :new.status = 'order04' THEN
IF :old.appointment_id = :new.appointment_id THEN
:new.status := 'order06';
END IF;
SELECT seq_appraise.nextval INTO vs_appraise_id FROM dual;
INSERT INTO t_appraise (
appraise_id, customer_id, customer_name, star_level, comments
) VALUES (
vs_appraise_id, :new.customer_id, :new.customer_name, 100, '系统默认好评'
);
END IF;
END;
测试触发器,File — New — Test Window,输入执行语句,如下图,点击红框中的按钮或者按F9进行调试。