Purpose
TIMESTAMP_TO_SCN() returns the system change number (SCN) corresponding to a timestamp, which is the input argument of this function. The input argument belongs to the TIMESTAMP type, and the return value belongs to 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