| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.misc -> Need info on Triggers
Hi
I have a table with many columns( x,y,z). I need to capture changes to
the table. I need to capture changes only for(x) some specific columns,
but not
for all columns. for ex: I need to capture updates for column x, but not
for columns y & Z. I also need to capture deletes from the table.
I know that i have to write a trigger to capture changes to the table.
my question is wether one trigger is enough to capture changes to
various columns or i need one trigger each to capture changes.
please advise. any additional input on triggers is welcome
please send replies if possible to the following address praveen_andugula_at_nt.com
thanks
praveen
Received on Tue Feb 11 1997 - 00:00:00 CST
![]() |
![]() |