There is an oracle table with 75 columns and as and when any of the column data is being updated, we want to capture the updated columns name,old data and new data.
We have tried with a DB trigger "before update with row level statement" .But the problem is, we don't know what are the columns that get updated i.e.(out of 75 columns,only some may get updated) and we need to keep a track of that.
We don't want to add 'if conditions' in DB trigger like
if ld.columnname<>:new.columnname then
For all the 75 columns....
Is there any way to identify only the updated columns?"