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 -> Re: Trigger to Capture Changes

Re: Trigger to Capture Changes

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: 1997/04/02
Message-ID: <3343353A.3659@exesolutions.com>#1/1

> What I really need is a way to capture just the columns that have
> changed, and generate a report containing just the changes.

I would look at a Before Insert trigger and a comparison of :old. and :new. on a field by field basis. There are probably better ways but this is the first one that comes to mind.

Daniel A. Morgan Received on Wed Apr 02 1997 - 00:00:00 CST

Original text of this message

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