oracle int自增长

1. 先建表（此处略去）
2. 创建Sequence

  create sequence template_seq
  start with 1
  increment by 1
  nocycle
  cache 99999

3.创建触发器

create trigger template_trig before
insert on template for each row--template是表名
declare
nextid number;
begin
if:new.templateid is null or :new.templateid=0 then--templateid是template表的列
select template_seq.nextval into nextid from sys.dual;
:new.templateid:=nextid;
end if;
end;