实现步骤:先创建序列,后创建触发器
1、创建序列
1 create sequence 序列名2 increment by 13 start with 14 maxvalue 999999999;
2、创建触发器
1 create or replace trigger 触发器名2 before 3 insert on 表名4 for each row5 declare6 -- local variables here7 begin8 SELECT 序列名.Nextval INTO :NEW.自增列 FROM DUAL;9 end 触发器名;