Display the Time a Row was Last Updated
--
-- Display the Time a Row was Last Updated.
--
 
SET PAUSE ON
SET PAUSE 'Press Return to Continue'
SET PAGESIZE 60
SET LINESIZE 300
SET VERIFY OFF
 
SELECT
   SCN_TO_TIMESTAMP ( ora_rowscn )
FROM 
  &table_name
WHERE
  &where_clause
/

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License