修改一個(gè)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 閱讀(125) 評(píng)論(0) 編輯 收藏 所屬分類: 10 Database