批量修改序列的值.sql

--批量修改序列的值.sql.
spool "用户所有SEQ增加100万.sql";
set head off;
SET FEEDBACK OFF;
select 'alter sequence '||sequence_name||' increment by 1000000 ;' From user_sequences;
select '-------------------------------------------' from dual;
select 'select '||sequence_name ||'.nextval '||'from dual;' from user_sequences;
select 'alter sequence '||sequence_name||' increment by 1;' From user_sequences;
select 'select '||sequence_name ||'.nextval '||'from dual;' from user_sequences;
spool off;
set head on;
SET FEEDBACK ON;
--执行"用户所有SEQ增加100万.sql"