The above methods can be used after the fact. Before the fact, you can add a column to the table called UPDATE_TIME...
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
defined with the DATE datatype. Then create a trigger on the table which sets the UPDATE_TIME column to SYSDATE on any INSERT or UPDATE command on the table. Determining the last updated row is as simple as querying for the row with the MAX(UPDATE_TIME) value. This method does require you to set up the column and trigger beforehand.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.