I want to be able to see when a specific column was changed. To clarify, I don't want to see when a row was changed. I was able to do that with ROWDEPENDENCIES and triggers with a timestamp. With ROWDEPENDICIES I can see when the whole row was modified last but I specifically want to find out when the a specific column was changed.
To clarify, I want the following table:
id Name Name_modified_on Salary Salary_modified_on
1 Johnson 11.03.16 10:54:27 5000 11.03.16 10:51:27
How do I do that? Thanks. PS: I'm running Oracle 11g.