Oracle DBA Queries - Database status, uptime, how big is it, etc...
-- -- 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 /