修改一個Sequence
alter sequence TCIN_ID increment by 1 nocache;
select TCIN_ID.nextval from dual;
alter sequence TCIN_ID increment by 1 nocache;
declare
LastValue integer;
begin
loop
select TCIN_ID.currval into LastValue from dual;
exit when LastValue >= 105200 - 1;
select TCIN_ID.nextval into LastValue from dual;
end loop;
end;
/
alter sequence TCIN_ID increment by 1 cache 20;
select TCIN_ID.nextval from dual;
alter sequence TCIN_ID increment by 1 nocache;
declare
LastValue integer;
begin
loop
select TCIN_ID.currval into LastValue from dual;
exit when LastValue >= 105200 - 1;
select TCIN_ID.nextval into LastValue from dual;
end loop;
end;
/
alter sequence TCIN_ID increment by 1 cache 20;
posted on 2007-08-01 20:43 MingIsMe 閱讀(123) 評論(0) 編輯 收藏 所屬分類: 10 Database