oracle 创建表id 自动增长 触发器

create sequence SEQ_bb
minvalue 1
maxvalue 99999999
start with 1
increment by 1
cache 50

create trigger TG_bu40_maintain_num_Identity before

insert on " FFMATERIAL_DETAILS" for each row when(new.id is null)

begin

select SEQ_bb.nextval into:new.id from dual;

end;