oracle 创建自增序列

create sequence seq_sys_user minvalue 1 maxvalue 999999999999999999 start with 1 increment by 1 nocache--创建序列

INSERT INTO SYS_USER(id,user_name,password)VALUES(seq_sys_user.NEXTVAL,1,11);--自增插入测试

SELECT * FROM SYS_USER;

select * from user_sequences;--查询所有已经建好的序列

 

select seq_sys_user.NEXTVAL from dual; --查询seq_sys_user SYS_USER 的下一个序列

DROP SEQUENCE seq_sys_user;--删除序列