René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback
 

SCN_TO_TIMESTAMP [Oracle SQL]

select scn_to_timestamp(some-scn) from ...
scn_to_timestamp returns the approximative timestamp for an SCN. However, the granularity of scn_to_timestamp seems to be three seconds, that is, scn_to_timestamp for SCNs within the same three second period might return the same timestamp.
See ora_rowscn for an example.