Oracle 修改序列步长

一、查询所有序列

# 需要用管理员执行
select * from dba_sequences where sequence_owner='用户';

二、修改步长

# ALTER SEQUENCE 序列名 INCREMENT BY 步长;
ALTER SEQUENCE test_seq INCREMENT BY 100;

三、获取下一序列值

# select 序列名.nextval from dual;
select test_seq.nextval from dual;

四、获取当前序列值

# select 序列名.currval from dual;
select test_seq.currval from dual;