ORCALE 自動(dòng)編號
TB_OA_DUANXIN 表中的 OADX_ID 字段為自動(dòng)增長
首先創(chuàng)個(gè)sequence :
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;
create or replace trigger TR_TB_OA_DUANXIN_ID_INC
declare
tmp NUMBER;
begin
end TR_TB_OA_DUANXIN_ID_INC;
posted on 2009-04-06 12:20 胡鵬 閱讀(281) 評論(0) 編輯 收藏 所屬分類: 數(shù)據(jù)庫