[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)
Thanks,
Vu
Other related posts: