Oracle查询和修改序列

查询序列

select * from user_sequences where sequence_name like '%XXXXXX%'

修改序列

1. 先修改序列步长

ALTER SEQUENCE seq_t_test INCREMENT BY n;

2. 然后做一次将序列更新至新的点

SELECT
	seq_t_test.nextval
FROM
	dual;

3. 最后将步长改回来

ALTER SEQUENCE seq_t_test INCREMENT BY n;