oracel将序列值改为当前系统最大值方法

--修改序列为表中最大值
declare
  Max_Id NUMBER(10);
  Current_Value NUMBER(10);
BEGIN
  SELECT max(to_number(user_code)) INTO Max_Id FROM F_USERINFO t  where  t.user_code!='u0000000';
  loop
      SELECT S_USERCODE.NEXTVAL INTO Current_Value FROM dual;
    exit when Current_Value >= Max_Id ; -- 终止条件
  end loop;
end;

查询表中序列

SELECT S_USERCODE.NEXTVAL FROM DUAL;