案例描述：sql
将表vehicle中列pay_money_remain的值分为2/3，1/3再更新到表vehicle的pay_money_remain，disinfectionbal_remainspa
表：vehiclecode
列：pay_money_remain，disinfectionbal_remainrem
update vehicle ve
set (ve.pay_money_remain, ve.disinfectionbal_remain) = (select trunc(v.pay_money_remain * 2 / 3),
(v.pay_money_remain -
trunc(v.pay_money_remain * 2 / 3))
from vehicle v
where ve.vehicle_iq_code =
v.vehicle_iq_code);
commit;
总结：it
update A a set(a.a1,a.a2,a.a3) = (select b.b1,b.b2,b.b3 from B b where 条件) where 条件;io
commit;class