Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Multi row updates on the primary key

Re: Multi row updates on the primary key

From: Dom <semineld_at_icon.co.za>
Date: 1997/05/26
Message-ID: <01bc6a15$d0670080$29dd1ac4@dominique.icon.co.za>#1/1

Hi,
did you try :
update table2 a set col_sum = (select sum(col_sum) from table1 b where a.key1=b.key2 and a.key2=b.key2 and ... group by b.key1, b.key2, ...); Received on Mon May 26 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US