例如: CREATE OR REPLACE TRIGGER APPS.TRIGER_T1 BEFORE INSERT ON USER.TABLE_NAME REFERENCING OLD AS OLD NEW AS NEW FOR EACH ROW BEGIN SELECT GS_SEQ_S.NEXTVAL INTO :NEW.TRANSACTION_ID FROM DUAL;END; /
create trigger trigger_name after update on tablea for each row begin insert into tableb values(1,:new.name); --:new更新后的行的name值. 一提 --:old.name更新前的name值 end;
create trigger trigger_name after update on tablea for each row begin insert into tableb values(1,:new.name); --:new更新后的行的name值. 一提 --:old.name更新前的name值 end; 同意,.new就可以了。
CREATE OR REPLACE TRIGGER APPS.TRIGER_T1
BEFORE INSERT
ON USER.TABLE_NAME
REFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW
BEGIN SELECT GS_SEQ_S.NEXTVAL
INTO :NEW.TRANSACTION_ID
FROM DUAL;END;
/
after update on tablea
for each row
begin
insert into tableb values(1,:new.name); --:new更新后的行的name值.
一提 --:old.name更新前的name值
end;
after update on tablea
for each row
begin
insert into tableb values(1,:new.name); --:new更新后的行的name值.
一提 --:old.name更新前的name值
end;
同意,.new就可以了。