oracle 设置主键自增

---自增序列
CREATE SEQUENCE T_SYS_USER_SEQ
MINVALUE 1
NOMAXVALUE
INCREMENT BY 1
START WITH 1 NOCACHE ;
T_SYS_USER_SEQ 为序列的名，序列从1开始。

 

insert into sys_users(user_id,user_name,user_pwd,sex)
       values(T_SYS_USER_SEQ.NEXTVAL,'shaoduo','shao111','男') ;
       commit ;