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!

How to see inserted or updated record when they are inserted or updated?

XandotNov 26 2013 — edited Nov 28 2013

Hello friends ,

I have a huge table with, it do NOT contain any field with date or date and time.

I want date and time when record are inserted or updated.....

There are many row inserted in table ,So how to know when rows are inserted in particular table.

& How to retrieve it using SQL query?

My database is 10gR2 and win-xp is the OS.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 26 2013

Added on Nov 26 2013

#general-database-discussions

10 comments

1,300 views