为什么oracle触发器编译有错?
CREATE OR REPLACE TRIGGER TRG_UPGRADE
AFTER UPDATE
ON BONUS
FOR EACH ROW
WHEN(OLD.JOB = 'SALSMAN' OR OLD.JOB = 'CLERK' OR OLD.JOB = 'ANALYST')
BEGIN
IF :NEW.JOB = 'MANAGER' THEN
:NEW.SAL= :OLD.SAL * 1.1;
END IF;
END;
初学者找不到错误哎~~
CREATE OR REPLACE TRIGGER TRG_UPGRADE
AFTER UPDATE
ON BONUS
FOR EACH ROW
WHEN(OLD.JOB = 'SALSMAN' OR OLD.JOB = 'CLERK' OR OLD.JOB = 'ANALYST')
BEGIN
IF :NEW.JOB = 'MANAGER' THEN
:NEW.SAL= :OLD.SAL * 1.1;
END IF;
END;
初学者找不到错误哎~~
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货