Re: Trigger on specific column

If a triggering statement specifies UPDATE, an optional list of columns can be included in the triggering statement. If you include a column list, the trigger is fired on an UPDATE statement only when one of the specified columns is updated. If you omit a column list, the trigger is fired when any column of the associated table is updated. A column list cannot be specified for INSERT or DELETE triggering statements.

The previous example of the trigger might have included a column list in the triggering statement, as in

. . . BEFORE UPDATE OF ename ON emp . . .

Regards,

Markus

<bshah_at_sportsmail.com> schrieb im Newsbeitrag news:8vc3u1$es$1_at_nnrp1.deja.com...
> Hi,
>
> How do you create a trigger for a specific column (or set of columns)?
> For example, I would like to take one action for an update to col x,
> and another action for an update to col y.
>
> Thanks in advance.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Nov 21 2000 - 01:01:44 CST