Oracle 10g ORA_ROWSCN Pseudocolumn

13 October 2009

Oracle 10g maintains a pseudocolumn the tracks the revision number of records. It’s called ORA_ROWSCN. (SCN stands for System Change Number.) There’s also a handy function, SCN_TO_TIMESTAMP, which will convert that revision number to a human-readable date and time.

But there are a few caveats:

This article has a good description and two enlightening examples for those interested.