시퀀스값 변경

select 'alter sequence ' || sequence_name || ' increment by 1000;'

  from dba_sequences

 where sequence_owner = 'USER';

 

 

select 'select ' || sequence_name || '. nextval from dual;'

  from dba_sequences

 where sequence_owner = 'USER';