declare
cursor c_test IS
select salary,costm from xq_user_test
where USER_ID in(2,3,4)
for update of salary;
begin
for v_test in c_test loop
update xq_user_test
set salary=1000,costm= costm+10
where current of c_test;
end loop;
commit;
end;select那个字段,锁定那个字段
cursor c_test IS
select salary,costm from xq_user_test
where USER_ID in(2,3,4)
for update of salary;
begin
for v_test in c_test loop
update xq_user_test
set salary=1000,costm= costm+10
where current of c_test;
end loop;
commit;
end;select那个字段,锁定那个字段
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货