Oracle 还原序列
declaren number(10);tsql varchar2(100);beginselect SEQ_APP_INFO_ADBIT_ID.nextval into n from dual;n:=-(n-1);tsql:= 'alter sequence SEQ_APP_INFO_ADBIT_ID increment by '|| n;execute immediate tsql;select SEQ_APP_INFO_ADBIT_ID.nextval into n from dual;tsql:= 'alter sequence SEQ_APP_INFO_ADBIT_ID increment by 1 ';execute immediate tsql;end;
?
