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: After Update Trigger

Re: After Update Trigger

From: Serge Rielau <srielau_at_ca.ibm.com>
Date: Mon, 20 Nov 2006 13:03:22 -0500
Message-ID: <4se8vbFuhnp3U1@mid.individual.net>


Serge Rielau wrote:
> The way I understand it the OP tries to maintain a derived column
> SUM(col2) OVER(PARTITION BY col1) within the table.
> That is any time one of the rows in the group is changed all others need
> to be updated.
> Questionable design.... Perhaps reading up on materialized views would
> be in order.

Actually I spoke in haste. Ignore this part. It's wrong.

-- 
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

WAIUG Conference
http://www.iiug.org/waiug/present/Forum2006/Forum2006.html
Received on Mon Nov 20 2006 - 12:03:22 CST

Original text of this message

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