mld@ORCL> conn scott/tiger
已连接。
scott@ORCL> select deptno,ora_rowscn,scn_to_timestamp(ora_rowscn) ts from dept;
DEPTNO ORA_ROWSCN TS
---------- ---------- ---------------------------------------------------------
-----------------
10 529426 30-8月 -05 03.05.26.000000000 下午
20 529426 30-8月 -05 03.05.26.000000000 下午
30 529426 30-8月 -05 03.05.26.000000000 下午
40 529426 30-8月 -05 03.05.26.000000000 下午
scott@ORCL> select min(ora_rowscn) from dept;
MIN(ORA_ROWSCN)
---------------
529426
scott@ORCL> select scn_to_timestamp(min(ora_rowscn)) from dept;
SCN_TO_TIMESTAMP(MIN(ORA_ROWSCN))
---------------------------------------------------------------------------
30-8月 -05 03.05.26.000000000 下午
scott@ORCL>
scott@ORCL>
scott@ORCL>
scott@ORCL>
posted on 2009-05-05 23:06 donnie 阅读(615) 评论(0) 编辑 收藏 所属分类: database