create table zdq_up (serial number,usernumber varchar2 (40),spip varchar2 (40),userid varchar2 (40))//serial为递增列declarei int;j int;begini :=0;j :=0;select count(*) into j from zdq_up;loopupdate s2000_user_subscription aset a.freetime='20000909235959',a.nextrentdate='20990909'where a.serial>=i and a.serial<=i+500 and exists (select 1 from zdq_up b where b.usercode=a.usernumber and b.productid=a.spip and b.subscribeopid=a.userid);commit;i := i + 500;exit when i>j;end loop;end;/
