CREATE TRIGGER emp_trigr AFTER UPDATE ON emp FOR EACH ROW BEGIN ...... END;
LZ的输出是不是指的output呀。
给你一个简单的范例,自己修改下就可以了CREATE OR REPLACE TRIGGER EM.TRI_EMP_U AFTER DELETE OR UPDATE OF STATE ON EM.EMP FOR EACH ROW DECLARE ll_seq canp.table_key_seq.key_seq_num%type; BEGIN IF deleting then
Raise_application_error(-20000, '#工资总量低于20000的信息#'); elsif updating then IF :OLD.STATE='0' AND :NEW.STATE='1' THEN --更新语句 END IF; END IF; EXCEPTION WHEN OTHERS THEN -- Consider logging the error and then re-raise RAISE; END ;
AFTER UPDATE ON emp
FOR EACH ROW
BEGIN
......
END;
LZ的输出是不是指的output呀。
AFTER DELETE OR UPDATE
OF STATE
ON EM.EMP
FOR EACH ROW
DECLARE
ll_seq canp.table_key_seq.key_seq_num%type;
BEGIN
IF deleting then
Raise_application_error(-20000, '#工资总量低于20000的信息#'); elsif updating then
IF :OLD.STATE='0' AND :NEW.STATE='1' THEN
--更新语句
END IF;
END IF;
EXCEPTION
WHEN OTHERS THEN
-- Consider logging the error and then re-raise
RAISE;
END ;