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。其实没啥用

 

参考:https://zhidao.baidu.com/question/72099360.html

posted @ 2021-01-06 22:20  masha2017  阅读(1131)  评论(0编辑  收藏  举报