Oracle使用触发器实现自增ID备忘录

userinfo表id需要实现自增效果

1.创建序列
 

-- Create sequence 
create sequence seq_userinfo
minvalue 1
start with 1
increment by 1;

2.创建触发器

create or replace trigger tigger_userinfo
  before insert on userinfo  
  for each row
declare
begin
   select SEQ_userinfo.nextval into:New.id from dual; 
end tigger_userinfo;