Description: The TIMESTAMP_TO_SCN function 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.
Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 05th, 2009
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.)INSERTINTO orders (order_id, order_date, customer_id, order_total)VALUES(5000,SYSTIMESTAMP,188,2345);1ROW created.COMMIT;COMMIT complete.SELECT TIMESTAMP_TO_SCN(order_date)FROM orders
WHERE order_id =5000;
SQL University.net courses meet the most demanding needs of the business world for advanced education
in a cost-effective manner. SQL University.net courses are available immediately for IT professionals
and can be taken without disruption of your workplace schedule or processes.
Compared to traditional travel-based training, SQL University.net saves time and valuable corporate
resources, allowing companies to do more with less. That's our mission, and that's what we deliver.