TIMESTAMP_TO_SCN(<timestamp>)
-- The following example inserts a row into the oe.orders table
-- and then uses TIMESTAMP_TO_SCN to determine the system change
-- number of the insert operation. (The actual SCN returned will
-- differ on each system.)
INSERT INTO orders (order_id, order_date, customer_id, order_total)
VALUES (5000, SYSTIMESTAMP, 188, 2345);
1 ROW created.
COMMIT;
COMMIT complete.
SELECT TIMESTAMP_TO_SCN(order_date) FROM orders
WHERE order_id = 5000;
TIMESTAMP_TO_SCN(ORDER_DATE)
----------------------------
574100