Re: Summation

Brice Toth wrote:
>
> Hi. I'm relatively new to Oracle and SQL. My question
> is this: I have a table with columns x and y which are
> both integer values. i need to get the sum of the values
> in x and in y to put into column z. i need the sum to
> occur automatically whenever the values in x and y change.

  You can use database trigger to do it.

---
Name   : Lun Wing San (Certified Oracle Database Administrator)

Title  : Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841

This posting represents the personal opinions of the author. It is not the
official opinion or policy of the author's employer. Warranty expired when you
opened this article and I will not be responsible for its contents or use.