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!

Need to know the timestamp of the inserted rows in a table

unknown-709333Apr 19 2011 — edited Apr 19 2011
Hello All,

Thanks in advance, Hope all are doing good.

I have a question, I wanted to know the time & date of the data which is inserted into the Oracle tables, Is there any way to find out? We dont have any columns in a table to take a sysdate by default when the row is inserted, I need to check the date & time of all the rows in a table.

Can someone please help me on this??

Thanks,
Mallik
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 17 2011
Added on Apr 19 2011
2 comments
685 views