How to find out when an Oracle table was updated the last time

by

I’m really late to this party but here’s how I did it:

SELECT SCN_TO_TIMESTAMP(MAX(ora_rowscn)) from myTable;

It’s close enough for my purposes.

More Related Contents:

  1. How to uninstall / completely remove Oracle 11g (client)?
  2. How can I set a custom date time format in Oracle SQL Developer?
  3. Get counts of all tables in a schema
  4. Determining location of relevant tnsnames.ora file
  5. Default row ordering for select query in oracle
  6. oracle convert unix epoch time to date
  7. Oracle trigger after insert or delete
  8. ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
  9. Difference between a user and a schema in Oracle?
  10. Base64 encoding and decoding in oracle
  11. What is the dual table in Oracle?
  12. How to avoid variable substitution in Oracle SQL Developer
  13. Recursion In Oracle
  14. creating parameterized views in oracle11g
  15. Oracle’s default date format is YYYY-MM-DD, WHY?
  16. PL/SQL print out ref cursor returned by a stored procedure
  17. How to use a table type in a SELECT FROM statement?
  18. Default Schema in Oracle Connection URL
  19. how to replace multiple strings together in Oracle
  20. Dynamically pivoting a table Oracle
  21. How do you get nicely formatted results from an Oracle procedure that returns a reference cursor?
  22. Oracle: how to INSERT if a row doesn’t exist
  23. Valid Date Checks in Oracle
  24. Functions vs procedures in Oracle
  25. Oracle: difference between max(id)+1 and sequence.nextval
  26. HikariCP: What database level timeouts should be considered to set maxLifetime for Oracle 11g
  27. How to call an Oracle function with a Ref Cursor as Out-parameter from C#?
  28. How to Register Pluggable Database(PDB) with new created LISTENER
  29. Grant Select on all Tables Owned By Specific User
  30. ORA-12704: character set mismatch

Leave a Comment