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;
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;