一、查询所有序列
# 需要用管理员执行
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;