Oracle 如何更改顺序。下一个增加量

create table a (sno number(10));

create sequence test 
start with 1
increment by 1
nocycle
nocache;

insert into a (sno) values(test.nextval);
复制

 select max(sno) from a;

max(sno)
---------
1000
复制

create table a (sno number(10));

create sequence test start with 999
 increment by 1 nocycle nocache;

insert into a (sno) values(test.nextval);
insert into a (sno) values(test.nextval);

alter sequence test increment by 50;

insert into a (sno) values(test.nextval);
insert into a (sno) values(test.nextval);
insert into a (sno) values(test.nextval);

select * from a;

       SNO
----------
       999
      1000
      1050
      1100
      1150
复制