***************************************************************************
DATABASE ENTRY
***************************************************************************
(size = 316, compat size = 316, section max = 1, section in-use = 1,
last-recid= 0, old-recno = 0, last-recno = 0)
(extent = 1, blkno = 1, numrecs = 1)
01/12/2015 18:49:02
DB Name "ODSPTDB"
Database flags = 0x00404000 0x00001000
Controlfile Creation Timestamp 01/12/2015 18:49:02
Incmplt recovery scn: 0x0000.00000000
Resetlogs scn: 0x0000.00000001 Resetlogs Timestamp 01/12/2015 18:49:02
Prior resetlogs scn: 0x0000.00000000 Prior resetlogs Timestamp 01/01/1988 00:00:00
Redo Version: compatible=0xb100000
#Data files = 99, #Online files = 99
Database checkpoint: Thread=1 scn: 0x0c54.65c08713
Threads: #Enabled=1, #Open=0, Head=0, Tail=0
--------------------------
SQL> select to_number('0c5465c08713','xxxxxxxxxxxxxxxxxxxxxxxxx') abc_scn from dual;