<<Back to DB Administration Main Page
How to Find SCN from Timestamp in Oracle
SQL> Col scn for 999999999SQL> select timestamp_to_scn(to_timestamp('27-12-2018 15:20:00','DD-MM-YYYY HH24:MI:SS')) as scn from dual;
SCN
———-
845396
How to Find Timestamp from SCN in Oracle
SQL> alter session set nls_date_format='DD-MON-RRRR HH24:MI:SS';SQL> select scn_to_timestamp(845396) as timestamp from dual;
TIMESTAMP
—————————————————————————
27-12-2018 15:20:02
How to Find the Current SCN in Oracle Using DBMS_FLASHBACK
SQL> select DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER from dual;GET_SYSTEM_CHANGE_NUMBER
————————
845401
Comments
Post a Comment