oracle数据库设置id递增

1.字段名 :ID

   建立序列：

    create sequence P_PARTROUTE_SUN_seq;

  建立触发器：

   create trigger P_PARTROUTE_SUN_tri

   before INSERT on P_PARTROUTE_SUN for each row 

   BEGIN

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

   end;

2.字段名是：WARNINDEX_ID

 建立序列：

    create sequence P_PARTROUTE_seq;

  建立触发器：

   create trigger P_PARTROUTE_tri

   before INSERT on P_PARTROUTE for each row 

   BEGIN

   select P_PARTROUTE_seq.nextval into :new.warnindex_Id from dual;

   end;