ORA_ROWSCN returns the conservative upper bound system change number (SCN) of the most recent change to the row. This is useful for determining approximately when a row was last updated. Example
Get the system change number of the last operation on the items table
SELECT ORA_ROWSCN, item_name FROM items WHERE item_id = 10;
