oracle实现自增列

1.创建表序列

create sequence T_ROLE_sequence
increment by 1
start with 1
nomaxvalue
nocycle
nocache

 

2.创建表触发器

--角色表触发器
create trigger T_ROLE_trig before
insert on T_ROLE for each row when(new.ROLE_ID is null)
begin
  select T_ROLE_sequence.nextval into:new.ROLE_ID from dual;
end;

3.到这里就可以实现自增列了，还不赶紧试试