Oracle使用触发器实现自增ID

userinfo表id需要实现自增效果

创建序列

代码

Create sequence

create sequence seq_userinfo

minvalue

start with

increment by ;

创建触发器

代码

create or replace trigger tigger_userinfo

before insert on userinfo

for each row

declare

begin

select SEQ_userinfonextval into:Newid from dual;

end tigger_userinfo;