alter SEQUENCE customers_seq START WITH 1 INCREMENT BY -最大数;
select customers_seq.nextval from dual;
alter SEQUENCE customers_seq START WITH 1 INCREMENT BY 1;
select customers_seq.nextval from dual;
alter SEQUENCE customers_seq START WITH 1 INCREMENT BY 1;
另一种就是改increment的值,然后select让它回到原来的初值,然后再将increment值改回去,如:
select seq.nextval from dual;
---记下此值,假设为999,并假设要让它回到1,那么
alter sequence seq increment by -998;
select seq.nextval from dual;
此时seq的已经回到了1.
alter sequence seq increment by 原来的增量;