oracle的触发器中REFERENCING的使用
create or replace trigger WJJ02_TRI before insert on fpme REFERENCING OLD AS "O" NEW AS "N" FOR EACH ROW begin SELECT SEQ_WJJ03.NEXTVAL INTO :N.ID FROM DUAL; end;
意思是说
用 O 代替 OLD,用 N 代替 NEW。其实没啥用
create or replace trigger WJJ02_TRI before insert on fpme REFERENCING OLD AS "O" NEW AS "N" FOR EACH ROW begin SELECT SEQ_WJJ03.NEXTVAL INTO :N.ID FROM DUAL; end;
意思是说
用 O 代替 OLD,用 N 代替 NEW。其实没啥用