Skip to Main Content
Forums

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!

Oracle DB - Row Update Timestamp

962990Sep 19 2012 — edited Sep 20 2012
I need to update a view with the Last Updated Time stamp whenever a row is updated in the source table or a new row is inserted. I need to do this without making any changes to the source table.

Is there any way to do this without impacting the source table and handle it within the view or when the view is getting refreshed.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 18 2012
Added on Sep 19 2012
#general-database-discussions, #oracle, #table, #update
7 comments
7,721 views