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

auauau

userinfo表id需要实现自增效果

1.创建序列
  -- Create sequence create sequence seq_userinfominvalue 1start with 1increment by 1;

2.创建触发器

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