create sequence

一、创建时设置序列的最大值与最小值

create sequence seq_test

minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
cache 20;

 

current sequence value:
select seqpart.currval from dual;

 

next sequence value:
select seqpart.nextval from dual;

 

二、创建时不设置属性时

Create sequence Seq_AA(序列名称) increment by 1 start with 1;