[askdba] Update SQL

  • From: VuCanDo <vuquyen@xxxxxxxxx>
  • To: askdba@xxxxxxxxxxxxx
  • Date: Thu, 10 Mar 2005 15:09:33 -0800

what's wrong with this update SQL spy_mart 12.5 millions and
spy_proc_prov 2.4 millions. It's take me 17 hours already and still
going now on Oracle 9.2 Solaris Sun

update spy_proc_prov p
set (p.paid_total,p.claim_ct) = (select sum(m.paid_amt),
count(m.proc_cd) from spy_mart m where p.prov_id = m.prov_id and
p.proc_cd=m.proc_cd group by prov_id, proc_cd)



Other related posts: