Oracle Database Discussions

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!

Last updated record in a table

misterimranJul 19 2011 — edited Mar 1 2013

Hello Guys,

I have a huge table with, it do NOT contain any field with date or date and time.
I just want to know when was the last record inserted and updated in this table? Oracle stores date and time stamp with each record. How to retrieve it using SQL query?

My database is 10gR2 and Linux is the OS.

Regards,
Imran

This post has been answered by CKPT on Jul 19 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 29 2013

Added on Jul 19 2011

#date, #general-database-discussions, #table, #update

7 comments

14,551 views