在一个表上建立触发器可以在触发器里再更新这个表吗?<在线>
CREATE OR REPLACE TRIGGER "TRI_SUM" AFTER
UPDATE ON "INDISUM" FOR EACH ROW BEGIN
IF UPDATING('JIAFEN') OR UPDATING('YONGFEN') OR UPDATING('JIANFEN') THEN
UPDATE INDISUM
SET NIANLEIJI = :NEW.JIAFEN - :NEW.YONGFEN - :NEW.JIANFEN,
PAIXU = :NEW.JIAFEN + :NEW.YONGFEN - :NEW.JIANFEN
WHERE "ID" = :OLD."ID";
END IF;
IF UPDATING('NIANLEIJI') OR UPDATING('SHANGNIAN') THEN
UPDATE INDISUM
SET ZONGLEIJI = :NEW.NIANLEIJI + :NEW.SHANGNIAN
WHERE "ID" = :OLD."ID";
END IF;
IF UPDATING('ZONGLEIJI') OR UPDATING('DONGJIE') THEN
UPDATE INDISUM
SET KEYONG = :NEW.ZONGLEIJI - :NEW.DONGJIE
WHERE "ID" = :OLD."ID";
END IF;
END TRI_SUM;