update bildtl a
set a.price =
(select ci.price/i.untnum
from item i,corpitem ci
where a.biltyp='SX'
and a.dat = to_date('2000-08-13','YYYY-MM-DD')
and a.corpid in (select id from corp where refid = 'KA049')
and nvl(a.refid1,'1') = '1')
and a.itmid = i.id
and i.guid = ci.item
and ci.corp = '7EAA86FB15F64431BA28ACAFDC98E3CB'
where
a.biltyp='SX'
and a.dat = to_date('2000-08-13','YYYY-MM-DD')
and a.corpid in (select id from corp where refid = 'KA049')
and nvl(a.refid1,'1') = '1'
通过update 恢复数据
最新推荐文章于 2023-04-07 15:16:53 发布