Re: trigger
From: (wrong string) ås <odd.morten.sveas_at_accenture.com>
Date: 21 Sep 2002 00:38:58 -0700
Message-ID: <4306a83.0209202338.309e7235_at_posting.google.com>
Date: 21 Sep 2002 00:38:58 -0700
Message-ID: <4306a83.0209202338.309e7235_at_posting.google.com>
therealmonkeylover_at_hotmail.com (Vinc) wrote in message news:<aff3d35.0209201549.5e7a41e8_at_posting.google.com>...
> Hi
>
> Assumed i have a table with two columns: name and date.
> Now i intend to write a trigger which automatically updates the
> column date if name is being updating.
> How can i do that?
>
> thanks
A assume you want to opdate the date column whith the current date and time:
Create a before update trigger for each row, and use the :new bind variable: :new.date := sysdate; Received on Sat Sep 21 2002 - 09:38:58 CEST