TB_OA_DUANXIN 表中的 OADX_ID 字段為自動(dòng)增長(zhǎng)
首先創(chuàng)個(gè)sequence :
create sequence SEQ_TB_OA_DUANXIN
minvalue 1
maxvalue 9999999999
start with 1
increment by 1
cache 20;
再創(chuàng)建個(gè)觸發(fā)器:
create or replace trigger TR_TB_OA_DUANXIN_ID_INC
before insert on TB_OA_DUANXIN
for each row
declare
-- local variables here
tmp NUMBER;
begin
select SEQ_TB_OA_DUANXIN.nextval into tmp from dual;
:new.OADX_ID := to_char(tmp);
end TR_TB_OA_DUANXIN_ID_INC;