创建序列:
create sequence auto_id
increment by 1
start with 1
minvalue = 1
maxvalue = 99999999
nocycle
cache 20;
创建触发器:
create or replace trigger triggername
before insert
on tablename
begin
/* 自动获得tablename表id字段的自动增加值*/
SELECT testidadd.nextval into :new.id from dual;
end;