Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Trigger to Capture Changes
> 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