//创建序列
create sequence t_seq
increment by 1
start with 100 maxvalue 999999;
//创建触发器
create trigger t_trigger before insert on t for each row
begin
select t_seq.nextval into :new.id from dual;//id需要自增的序列
end;
//创建序列
create sequence t_seq
increment by 1
start with 100 maxvalue 999999;
//创建触发器
create trigger t_trigger before insert on t for each row
begin
select t_seq.nextval into :new.id from dual;//id需要自增的序列
end;
转载于:https://www.cnblogs.com/appleying/archive/2011/03/31/2001202.html