创建序列
create sequence sample_seq
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
cache 20;
commit;
删除序列
DROP SEQUENCE SAMPLE_SEQ;
重置序列
-- 获取当前值,假设为 121
select sample_seq.nextval from dual;
-- 修改步长为 -(n-1)
alter sequence sample_seq increment by -120;
-- 获取当前值为 1
select sample_seq.nextval from dual;
-- 重设步长值为 1
alter sequence sample_seq increment by 1;