oracle sql修改序列为当前序列开始
declare
v_num integer;
last_value integer;
Begin
select SEQ_TBM_ID.NEXTVAL into last_value from dual;
Select max(tbm.tbm_id) into v_num From terminal_bak_manamge tbm;
loop
Select Seq_Tbm_Id.Currval into last_value From dual;
exit when last_value>= v_num;
Select Seq_Tbm_Id.Nextval into last_value From dual;
end loop;
end;
/