Re: Keeping track of data updates in Oracle 8 ?

On Fri, 19 Nov 2004 09:12:54 -0500, thomas goodwin <tom_goodwin_at_unc.edu> wrote:

> I have an Oracle database composed of questionnaire data. A few
>times a week, I use the UPDATE statement to change the values of a few
>fields. What is a good way to keep track of these updates? I would
>like to keep a record of what was updated, and when.
>
> thanks, tom g

Write a before update for each row trigger to insert your modifications in a separate table.

--
Sybrand Bakker, Senior Oracle DBA