Oracle通过序列号生成自增ID的触发器
时间:2019-03-07 16:52:39
收藏:0
阅读:360
create or replace trigger TRG_SEQ_ID before
insert on TABLE1 for each row
declare begin
if :new.ID>0 then return;
else select SEQ_ID.Nextval into :new.ID from dual;
end if;
end TRG_SEQ_ID;
原文:https://www.cnblogs.com/lihfeiblogs/p/10490234.html
评论(0)