批量修改Oracle序列值的存储过程

--更改步长 Alter sequence SEQ_FEE increment by 10; select SEQ_FEE.nextval from dual; --还原步长 Alter sequence mysq increment by 1; select 'SF'||LPAD(SEQ_FEE.NEXTVAL,12,'0') AS VAL FROM DUAL;