Friday, March 4, 2011

tidbit:Oracle:identify when row was changed

Great way to identify when table row was changed (within 3 second precision):

select scn_to_timestamp(ORA_ROWSCN ) from EMP WHERE ROWNUM < 10;

No comments:

Post a Comment