一、创建时设置序列的最大值与最小值
create sequence seq_test
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
cache 20;
maxvalue 999999999999999999999999999
start with 1
increment by 1
cache 20;
current sequence value:
select seqpart.currval from dual;
select seqpart.currval from dual;
next sequence value:
select seqpart.nextval from dual;
select seqpart.nextval from dual;
二、创建时不设置属性时
Create sequence Seq_AA(序列名称) increment by 1 start with 1;