Oracle自增序列字段

先创建sequence create sequence human_bi_xq_seq increment by 1 start with 1 minvalue 1 maxvalue 9999999999999 nocache order;

然后给表创建触发器 create or replace trigger human_bi_xq_trigger before insert on human_bi_xq for each row begin select human_bi_xq_seq.Nextval into:new.PID from sys.dual ; end;