Oracle10g中SCN與TimeStamp轉換

1 取得SCN

SQL> select dbms_flashback.get_system_change_number scn from dual;

       SCN
-----------------------------------------------------------------------
   2583787

2 使用scn_to_timestamp轉化為時間timestamp

SQL> select scn_to_timestamp(2583787) time from dual;

TIME
---------------------------------------------------------------------------
26-9月 -10 09.24.59.000000000 下午

3 使用timestamp_to_scn轉化為SCN

SQL> select timestamp_to_scn(scn_to_timestamp(2583787)) scn from dual;

       SCN
-----------------------------------------------------------------------
   2583787