通过update 恢复数据

 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'