Articles Tagged: DATE SCN

SQL>select current_scn from v$database; 7705798324 SQL> select timestamp_to_scn(to_timestamp(’24/09/2012 14:24:54′,’DD/MM/YYYY HH24:MI:SS’)) as scn from dual; SCN ———- 7705798324 SQL> SQL> select scn_to_timestamp(7705798324) as timestamp from dual; 24-SEP-12 02.24.52.000000000 PM Thank you for giving your valuable time to read the above information. If you want to be updated with all our articles send us the Invitation or […]