SQL> 

SQL> SELECT ora_rowscn, ename, sal
  2  FROM emp;



ORA_ROWSCN ENAME             SAL                                                

---------- ---------- ----------                                                
    529426 SMITH             800                                                
    529426 ALLEN            1600                                                
    529426 WARD             1250                                                
    529426 JONES            2975                                                
    529426 MARTIN           1250                                                
    529426 BLAKE            2850                                                
    529426 CLARK            2450                                                
    529426 SCOTT            3000                                                
    529426 KING             5000                                                
    529426 TURNER           1500                                                
    529426 ADAMS            1100                                                




ORA_ROWSCN ENAME             SAL                                                

---------- ---------- ----------                                                
    529426 JAMES             950                                                
    529426 FORD             3000                                                
    529426 MILLER           1300                                                



14 rows selected.



SQL> UPDATE emp
  2  SETsal = 6000
  3  WHERE ename = 'KING';




1 row updated.



SQL> commit;



Commit complete.



SQL> SELECT ora_rowscn, ename, sal
  2  FROM emp;




ORA_ROWSCN ENAME             SAL                                                

---------- ---------- ----------                                                
    653331 SMITH             800                                                
    653331 ALLEN            1600                                                
    653331 WARD             1250                                                
    653331 JONES            2975                                                
    653331 MARTIN           1250                                                
    653331 BLAKE            2850                                                
    653331 CLARK            2450                                                
    653331 SCOTT            3000                                                
    653331 KING             6000                                                
    653331 TURNER           1500                                                
    653331 ADAMS            1100                                                




ORA_ROWSCN ENAME             SAL                                                

---------- ---------- ----------                                                
    653331 JAMES             950                                                
    653331 FORD             3000                                                
    653331 MILLER           1300                                                



14 rows selected.



SQL> SELECT SCN_TO_TIMESTAMP(653331) FROM dual;



SCN_TO_TIMESTAMP(653331)                                                        


---------------------------------------------------------------------------     

20-JUN-06 11.03.59.000000000 PM