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;
Oracle通过序列号生成自增ID的触发器
原文：https://www.cnblogs.com/lihfeiblogs/p/10490234.html
