ORA-00927:缺少等号 [英] ORA-00927: missing equal sign

问题描述

我正在创建我的第一个sql触发器，

Im creating my first sql trigger,

CREATE OR REPLACE TRIGGER totalsalary
    AFTER INSERT ON Employee
    FOR EACH ROW
WHEN ( NEW.Dno IS NOT NULL )
BEGIN
    UPDATE Department
    SET totalSalary totalSalary + NEW.salary
    WHERE Dno = NEW.Dno;
END
;

但是我收到了此错误消息，我不知道如何解决

but i got this error message and i dont know how to fix it

Error at line 3: PL/SQL: ORA-00927: missing equal sign

1. CREATE OR REPLACE TRIGGER SueldoTotal
2.  AFTER INSERT ON EMPLEADO
3.  FOR EACH ROW
4. WHEN ( NEW.Dno IS NOT NULL )
5. BEGIN

推荐答案

设置totalSalary totalSalary + NEW.salary

SET totalSalary totalSalary + NEW.salary

SET 子句中有一个等号缺失.

CREATE OR REPLACE TRIGGER totalsalary
    AFTER INSERT ON Employee
    FOR EACH ROW
WHEN ( NEW.Dno IS NOT NULL )
BEGIN
    UPDATE Department
    SET totalSalary = totalSalary + :NEW.salary
    WHERE Dno = :NEW.Dno;
END;
/

NEW.salary

NEW.salary

此外，在引用旧值和新值时，这是不正确的:

Also, this is incorrect while referencing OLD and NEW values:

:NEW.salary

这篇关于ORA-00927:缺少等号的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！