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

/