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.到这里就可以实现自增列了,还不赶紧试试