Oracle Sequence 清零
Oracle Sequence 清零
create or replace procedure
reset_seq(seq_name in varchar2)
is
cur_val number;
begin
execute immediate
'select '||seq_name||'.nextval from dual' into cur_val;
execute immediate
'alter sequence '||seq_name||' increment by -'||cur_val||' minvalue 0';
execute immediate
'select '||seq_name||'.nextval from dual' into cur_val;
execute immediate
'alter sequence '||seq_name||' increment by 1 minvalue 0';
end;
评论暂时关闭