个人学习
先创建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;