declare v_num NUMBER(10); begin v_num:=1; while(v_num<1000) loop update comp_tskf_test_1 set uniquecoding=2872+v_num where id=4411502+v_num; v_num:=v_num+1; end loop; end;
下面是我写的一个简单的例子declarev_num NUMBER(10);beginv_num:=1;while(v_numloop update comp_tskf_test_1 set uniquecoding=2872+v_num where id=4411502+v_num; v_num:=v_num+1;end loop;end;