Purpose
The TIMESTAMP_TO_SCN() function takes a TIMESTAMP parameter and returns the corresponding System Change Number (SCN). The input parameter is of the TIMESTAMP type, and the return value is of the NUMBER type.
Syntax
TIMESTAMP_TO_SCN(timestamp)
Examples
obclient> SELECT TIMESTAMP_TO_SCN('2022-06-16 11:50:30.123451234') FROM DUAL;
+--------------------------------------------------+
| TIMESTAMP_TO_SCN('2022-06-1611:50:30.123451234') |
+--------------------------------------------------+
| 1655351430123451234 |
+--------------------------------------------------+
1 row in set