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