Tracking row changes in Oracle tables

It’s been a while since I posted anything work related but here’s one I discovered today. Have you ever needed to find out when a particular row was changed? From Oracle 10g there’s a feature which records the SCN number of a row change within the table in a pseudo-column called ora_rowscn. So for example: [...]