| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> comp.databases.theory -> Re: Historical data; how?
Anton Versteeg wrote:
> Perhaps the following: Create a history table that contains all the columns
> of the table you want keep a history of. Make the columns nullable. Then
> create a trigger that is invoked after an update and that inserts the old
> values into the history table. If a column didn't change then a NULL is
> inserted.
What if the column is changed to NULL?
Alan Gutierrez - ajglist_at_izzy.net Received on Fri Jan 17 2003 - 11:26:13 CST
 |
 |