Tracking changes to rows in Oracle 9i [message #39917] |
Fri, 23 August 2002 06:53 |
Ray Ruvinskiy
Messages: 1 Registered: August 2002
|
Junior Member |
|
|
Hi,
I would like to implement a history feature for my application whereby anytime one of the columns in one of my tables is updated, the time of update, name of the column, old value, and new value are stored in the "history table" corresponding to the table being updated.
I want to use triggers for this, but I can't find an elegant way of checking which columns are actually being modified. The only way I can think of doing that is by having as many if statements as there are columns, which is ugly if, say, there are 15 columns in the table.
Any suggestions would be appreciated.
|
|
|
|