The eg, had a missing join ..... On Fri, 11 Mar 2005 12:21:39 +0530, Abraham Kurian <kurian24@xxxxxxxxx> wrote: > hi , > I think its most likely to hit ORA-01427 > > This is what i did ..... > > SQL> update emp b set b.deptno = (select a.deptno > 2 from dept a > 3 where a.deptno = b.deptno); > > 14 rows updated. > > SQL> update emp b set (b.comm,b.sal) = ( select sum(b.comm) , sum(b.sal) > 2 from emp b > 3 group by empno , deptno); > update emp b set (b.comm,b.sal) = ( select sum(b.comm) , sum(b.sal) > * > ERROR at line 1: > ORA-01427: single-row subquery returns more than one row > > Regards > Kurian > > On Thu, 10 Mar 2005 15:09:33 -0800, VuCanDo <vuquyen@xxxxxxxxx> wrote: > > 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 > > > > >