Oracle 还原序列

最新推荐文章于 2021-04-15 14:17:20 发布

Programmer_ZhangDi

最新推荐文章于 2021-04-15 14:17:20 发布

阅读量317

点赞数 1

分类专栏： Oracle 文章标签： Oracle

本文链接：https://blog.youkuaiyun.com/Programmer_ZhangDi/article/details/83924982

版权

Oracle 专栏收录该内容

17 篇文章

订阅专栏

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;