更新触发触发器的相同记录

Question

我想使用由于插入记录而触发的触发器来更新同一记录。

当我尝试这样做，用下面的代码它给出了一个错误

DROP TRIGGER CONTROLLER_UPLOADER; 

CREATE OR REPLACE TRIGGER CONTROLLER_UPLOADER 

after insert ON CONTROLLER for each row 

begin 

    UPDATE CONTROLLER SET STATUS = 'STARTED' WHERE ID = (SELECT MAX(ID) FROM CONTROLLER); 

end; 

Answer 1

DROP TRIGGER CONTROLLER_UPLOADER; 

CREATE OR REPLACE TRIGGER CONTROLLER_UPLOADER 

BEFORE insert ON CONTROLLER for each row 

begin 

    :NEW.STATUS := 'STARTED'; 

end; 

注意“之前的”不“之后”。