DECLARE
i number;
j number;
BEGIN
i :=1;
j :=0;
selectcount(*) into j fromtablewhere scenaio =0 ;
loop
exitwhen i > j ;
updatetableset scenaio =1where scenaio =0and rownum <=5000;
i := i +5000;
commit;
END loop;
END;
posted on
2021-01-20 21:26陕西小楞娃
阅读(152)
评论(0)
编辑收藏举报