select * from user_sequences
alter sequence SYS_CUST_SEQ_SSN increment by X nocache; --算出差值,增加X差值
执行程序。。。。
alter sequence SEQ_name increment by 1 nocache; --改回原increment_by
oracle修改last_number值
最新推荐文章于 2022-10-14 10:31:39 发布
select * from user_sequences
alter sequence SYS_CUST_SEQ_SSN increment by X nocache; --算出差值,增加X差值
执行程序。。。。
alter sequence SEQ_name increment by 1 nocache; --改回原increment_by