Oracle通过序列号生成自增ID的触发器

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;