There are two ways to get the current SCN (System Change Number) for an oracle 10g and 11g database
DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER and V$database
Method 1: Using DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER function
SQL> SELECT TO_CHAR(dbms_flashback.get_system_change_number) FROM dual;
GET_SYSTEM_CHANGE_NUMBER
—————————————-
11626841778005
Method 2 : Using current_scn column from v$database;
SQL> SELECT TO_CHAR(CURRENT_SCN) FROM V$DATABASE;
CURRENT_SCN
——————–
11626841778008
