当前位置: 代码迷 >> SQL >> oracle 用拼接Sql 语句的模式修改序列Sequence
  详细解决方案

oracle 用拼接Sql 语句的模式修改序列Sequence

热度:94   发布时间:2016-05-05 11:09:19.0
oracle 用拼接Sql 语句的方式修改序列Sequence

select 'alter sequence '||user_sequences.sequence_name||' increment by 50000000 nocache;

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

alter sequence '||user_sequences.sequence_name||' increment by 1 nocache;'from user_sequences

?

  相关解决方案