Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to find out when a table was updated last?

843854May 6 2003 — edited May 6 2003
This is not a JDBC question in particular. It is a database question. But of course I'll be using JDBC for it...

Do most major databases allow you to find out the last time that anything in the table was updated? If so, how?


Also, is it possible to get the database to tell you all the tables that a query depends on? (including those tables referenced by any queries referenced by the query?).

Or if not, if it is possible at least to find out what tables and queries a specific query uses?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 3 2003
Added on May 6 2003
4 comments
463 views