Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Need info on Triggers

Need info on Triggers

From: PKA <praveen_andugula_at_nt.com>
Date: 1997/02/11
Message-ID: <330082EB.285E@nt.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US