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 ENDI 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; /更多推荐
发布评论