declare
n number(10);
tsql varchar2(100);
begin
select my_seg.nextval into n from dual;//my_seg為序列名
n:=-(n-1);
tsql:='alter sequence my_seg increment by'|| n;
execute immediate tsql;
select my_seg.nextval into n from dual;
tsql:='alter sequence my_seg increment by 1';
execute immediate tsql;
end;
/
n number(10);
tsql varchar2(100);
begin
select my_seg.nextval into n from dual;//my_seg為序列名
n:=-(n-1);
tsql:='alter sequence my_seg increment by'|| n;
execute immediate tsql;
select my_seg.nextval into n from dual;
tsql:='alter sequence my_seg increment by 1';
execute immediate tsql;
end;
/
想要它恢复只能删除之后再重新建一个。
当然,序列创建好后,也可以修改其属性,设置其当前值、递增(递减)的步长等。贴主可以按照IronPromises(铁诺)的办法去做。