设置totalSalary totalSalary + NEW.salary
您在 *
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
602392714
清零编程群