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
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24620620/viewspace-674905/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24620620/viewspace-674905/