Skip to Main Content
Forums

SQL & PL/SQL

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 insertion time of records in an oracle table

SheyAug 16 2013 — edited Aug 17 2013

Hi everybody,

I have a table with about 50,000 records in my Oracle database and there is a date column which shows the date that each record get inserted to the table, for example 04-Aug-13.

Is there any way that I can find out what time each record has been inserted?

For example: 04-Aug-13 4:20:00 PM. (For my existing records not future ones)

I searched over the internet and find some results but none of them seem to be practical.

Thanks for your help.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 14 2013
Added on Aug 16 2013
3 comments
6,413 views