oracle自增id的的问题

1.oracle添加自增id

数据库添加序列

---自增序列
CREATE SEQUENCE T_SYS_USER_SEQ
MINVALUE 1 
NOMAXVALUE 
INCREMENT BY 1 
START WITH 1 NOCACHE ;

设置触发器

--创建触发器
create or replace trigger T_SYS_USER_USER_ID_TRIGGER
  before insert on SYS_USERS  
  for each row
begin
  select T_SYS_USER_SEQ.nextval into :new.user_id from dual;
end T_SYS_USER_USER_ID_TRIGGER;

2.mybatis新增数据oracle获取自增id

--设置属性跟mysql一样
useGeneratedKeys="true" keyProperty="LID"  keyColumn="LID"
--接下来添加selectkey
<selectKey keyProperty="lid" resultType="String" order="BEFORE">
      select T_USER_SEQ.NEXTVAL + 1 FROM DUAL
    </selectKey>