DROP SEQUENCE WPP_ID_SEQ
CREATE 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
Oracle 重置排序 SEQUENCE
最新推荐文章于 2024-07-15 19:21:03 发布