//创建序列create sequence t_seq increment by 1 start with 100 maxvalue 999999;//创建触发器create trigger t_trigger before insert on t for each rowbegin
select t_seq.nextval into :new.id from dual;//id需要自增的序列
end;