Oracle 重置排序 SEQUENCE

来源:互联网 发布:ug数控编程手机壳 编辑:程序博客网 时间:2024/05/19 13:06
DROP SEQUENCE WPP_ID_SEQCREATE SEQUENCE WPP_ID_SEQ INCREMENT BY 1 START WITH 1;declare  i   number; j number;begin  i:= 0;  j:= 0;  loop    i := i + 1;    select WPP_ID_SEQ.Nextval into j from dual;  exit when i = 3502 ;  end loop;end;select WPP_ID_SEQ.Nextval from dual

原创粉丝点击