Hi All,
I have a table of 60 columns and million rows.
Now if any column is updated(of any row),I should get a log somewhere(in another table) that this particular column is updated.
I know, we can use triggers and check for
if old.col1<>new.col1 then ..
.
.
.
but since there are many columns and they might increase/ decrease in future, this type of trigger creation is hectic.
So, i am hoping if there is any other simpler way to know which column/columns are being updated.
Thanks,
Sail