TB_OA_DUANXIN 表中的 OADX_ID 字段為自動增長
首先創個sequence :
create sequence SEQ_TB_OA_DUANXIN
minvalue 1
maxvalue 9999999999
start with 1
increment by 1
cache 20;
再創建個觸發器:
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;