通过重建SEQUENCE实现修改序列当前值

select 'drop sequence '||sequence_name ||';
create sequence '||sequence_name||'
minvalue '||user_sequences.min_value||'
maxvalue '||user_sequences.max_value||'
start with '||user_sequences.last_number*10||'
increment by '||user_sequences.increment_by||'
cache '||user_sequences.cache_size||';' as create_sql
from user_sequences where last_number <1000;

得到语句后，再进行执行即可。