Re: Need info on triggers

From: N Prabhakar <prabhs_at_po.pacific.net.sg>
Date: 1997/02/13
Message-ID: <5dtlu5$mrr$3@newton.pacific.net.sg>#1/1

PKA <praveen_andugula_at_nt.com> wrote:
>Hi
>I need to capture changes to a table. The table has many columns and i
>need to capture changes to some specific columns. For this purpose i
>know that i need a row level trigger.my question is can I capture
>changes to various columns with a single trigger or i need to have a
>trigger for each column. Any help is appreciated.
>
>Thanks in advance
>Praveen
>praveen_andugula_at_nt.com

Hi there,

All you need is to create an single trigger on that table for that operation.

Within that you can check whether the column has been changed with 'old' and 'new' variables. If the column is changed, you can continue with the logic.

A single trigger for INSERT, UPDATE, DELETE will do..Alternatively you can write a trigger which will fire for INSERT / UPDATE / DELETE operation.

Regards

N.Prabhakar Received on Thu Feb 13 1997 - 00:00:00 CST