日期:2014-05-16  浏览次数:20518 次

Oracle 还原序列
declare
n   number(10);
tsql   varchar2(100);
begin
select   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; 

?