Re: simple trigger - beginner need help

daud11_at_hotmail.com wrote:

> Hi
>
> I am trying to create a trigger to automatically update column B after column
> A has been updated. For example, let say my table my-table has 2 cols colA
> and colB. I want whenever ColA is updated, colB get updated automatically but
> I am not sure how to write the trigger to do just that. I have tried using
> the code below but it still won't work.
>
> create trigger tr_update
> after update of colA on my-table
> for each row
> BEGIN
     :new.ColB = <some calculaton>;

> END;
>

  Maxim Received on Sat Jan 23 1999 - 16:01:15 CST