Tuesday, February 14, 2012

How to find last updates on table (oracle 10g)

SQL> SELECT SCN_TO_TIMESTAMP(MAX(ora_rowscn)) from scott.emp;
SCN_TO_TIMESTAMP(MAX(ORA_ROWSCN))
---------------------------------------------------------------------------
10-FEB-12 02.58.54.000000000 AM