Question

如何在oracle sql develop 的sequences中修改last_number值

Answer 1

算出当前值，和你要修改的值的差（正负都可以）假设为 100

alter sequence SEQ_name increment by 100 nocache;
select SEQ_name.nextval from dual;
alter sequence SEQ_name increment by 1 cache 20;

Answer 2

select LAST_NUMBER from all_sequences where sequence_name='SEQ_'
UPDATE all_sequences SET LAST_NUMBER = where sequence_name='SEQ_'
未测试

追问

这种方法貌似不行。

Answer 3

删除后重新建

追问

有没有其他方法呀？比如写sql更改。

追答

序列貌似没办法，只能删除重建