1、创建sequence
create sequence JEECG.SEQU_NT_PLFBGCSJB_ID minvalue 1 maxvalue 9999999999999999999999999999 start with 1 increment by 1 cache 20 order;
2、触发器trigger
create or replace trigger TRIG_PLFBGCSJB_ID before insert on NT_PLFBGCSJB for each row declare -- local variables here begin select SEQU_NT_PLFBGCSJB_ID.nextval into :new.id from dual; end TRIG_PLFBGCSJB_ID;
转载请注明原文地址: https://www.6miu.com/read-79901.html
