Oracle创建自增序列触发器

create table gd_wms_erp_1
(
dtlid varchar(10) not null,
 docno varchar(20) ,
 credate date,
 customerno varchar(20),
 goodsno   varchar(20),
 goodsqty   number(10),
 goodsunit  varchar(10),
 goodsprice number(10,6),
 lotno   varchar(10),
 suflag  varchar(2),
 saflag  varchar(2),
 propdate date,
 valdate date,
 primary key (dtlid)
 )
 
create sequence gd_wms_erp_1_seq
minvalue 1
maxvalue 999999999
start with 1
increment by 1
cache 10;

create or replace trigger  gd_wms_erp_1_seq_trigger      
before insert on gd_wms_erp_1      
for each row      
begin      
select gd_wms_erp_1_seq.nextval into :new.dtlid from dual;    
end ;