📋Steps in this guide1/1

Scn to timestamp and viceversa

-- Get current scn value:

oracle configurationintermediate

by OracleDba

12 views

Scn to timestamp and viceversa

Code/Command (click line numbers to comment):

-- Get current scn value:
select current_scn from v$database;
-- Get scn value at particular time:
select timestamp_to_scn('19-JAN-08:22:00:10') from dual;
-- Get timestamp from scn:
select scn_to_timestamp(224292)from dual;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!