How do you get the latest SCN in the database?

[murugappan]

Hi,

You can also find this way

$ sqlplus internal

SQL > col name format a40

SQL>select file#,name,to_char(checkpoint_time, 'HH24:Mm:SS') "Last CheckPoint" from v$datafile_header;


HTH