oracle 设置序列的值_oracle设置序列当前值

设置序列值的方法一般有如下两种，

1.删除重建
 

drop sequence seq_t;
create sequence seq_t;
increment by 1
start with 1//任何值
maxvalue 99999999999999;

2.修改步长再改回去

select seq_t.nextval from dual;//先看下当前值，比如a
alter sequence seq_t increment by b;     //b为预想的值和a的差
select seq_t.nextval from dual; //达到预想值
alter sequence seq_t increment by 1;//再改回步长为1

3.将序列值设置为id当前最大值

declare
  Max_Id NUMBER(10);
  Current_Value NUMBER(10);
BEGIN
  SELECT max(ID) INTO Max_Id FROM "LANGUAGE";
  loop
      SELECT LANGUAGE_SEQ.NEXTVAL INTO Current_Value FROM dual;
    exit when Current_Value >= Max_Id ; -- 终止条件
  end loop;
end;