declare
n number(10);
tsql varchar2(100);
begin
select SEQUENCE_SENSITIVE.nextval into n from dual;//SEQUENCE_SENSITIVE这是sequence的名字
n:=-(n-0);//此处的为0重置完为1 改成任何数字相应重置序列+1
tsql:='alter sequence SEQUENCE_SENSITIVE increment by'|| n;
execute immediate tsql;
select SEQUENCE_SENSITIVE.nextval into n from dual;
tsql:='alter sequence SEQUENCE_SENSITIVE increment by 1';
execute immediate tsql;
n number(10);
tsql varchar2(100);
begin
select SEQUENCE_SENSITIVE.nextval into n from dual;//SEQUENCE_SENSITIVE这是sequence的名字
n:=-(n-0);//此处的为0重置完为1 改成任何数字相应重置序列+1
tsql:='alter sequence SEQUENCE_SENSITIVE increment by'|| n;
execute immediate tsql;
select SEQUENCE_SENSITIVE.nextval into n from dual;
tsql:='alter sequence SEQUENCE_SENSITIVE increment by 1';
execute immediate tsql;
end;