Oracle 自增长字段 制作触发器

create sequence autoid
increment by 1
start with 1
minvalue 1
maxvalue 100000

//制作触发器
create trigger autoidinsert
before insert on table_name

for each row
begin
select autoid.nextval into:new.autoid from dual;
end;