Oracle® Database SQL Reference 10g Release 2 (10.2) Part Number B14200-01 |
|
|
View PDF |
Syntax
Purpose
TIMESTAMP_TO_SCN
takes as an argument a timestamp value and returns the approximate system change number (SCN) associated with that timestamp. The returned value is of datatype NUMBER
. This function is useful any time you want to know the SCN associated with a particular timestamp.
Examples
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