Thursday, April 29, 2010

How to get scn value from Database !

SQL> SELECT CURRENT_SCN FROM V$DATABASE;

CURRENT_SCN
-----------
8653578

SQL> SELECT DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER() FROM DUAL;

DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER()
-----------------------------------------
8653579

No comments:

Post a Comment