How To Convert SCN to Date and Date to SCN in Oracle

It is possible to convert SCN (system change number) to date and date to SCN in Oracle databases. This allows us to find out when a specific change in the database occurred.

Query Current SCN in Oracle

We can query the current SCN information in the database as follows.

Convert SCN to Date in Oracle

Convert Date to SCN in Oracle

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *