Oracle Trigger更新列，包含同一表中另一列的信息(Oracle Trigger update column with information from another column in

Oracle Trigger更新列，包含同一表中另一列的信息(Oracle Trigger update column with information from another column in the same table)

我需要在yyy表中创建一个触发器。 插入后，我必须使用test2列的相同信息更新test1列。

可能是这样的吗？

CREATE OR REPLACE TRIGGER TRG_update AFTER INSERT ON yyy FOR EACH ROW BEGIN UPDATE yyy SET TEST1 = :NEW.TEST2 END

I need to create a trigger in the yyy table. After a insert, I must update the test1 column with the same information of test2 column.

Could be like this?

CREATE OR REPLACE TRIGGER TRG_update AFTER INSERT ON yyy FOR EACH ROW BEGIN UPDATE yyy SET TEST1 = :NEW.TEST2 END

最满意答案

CREATE OR REPLACE TRIGGER TRG_update BEFORE INSERT ON yyy REFERENCING NEW AS NEW FOR EACH ROW BEGIN :NEW.TEST1 := :NEW.TEST2; END; / CREATE OR REPLACE TRIGGER TRG_update BEFORE INSERT ON yyy REFERENCING NEW AS NEW FOR EACH ROW BEGIN :NEW.TEST1 := :NEW.TEST2; END; /