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!

update modify date column with sysdate

406871Dec 4 2008 — edited Dec 4 2008
Hello,
I want to add a new column, modify_date, to an existing table.

This column should have sysdate when ever a record is updated.

Please let me know the best way of doing this same.

Trigger? I think some mutating problem?

Thanks&Regards
This post has been answered by Karthick2003 on Dec 4 2008
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 1 2009
Added on Dec 4 2008
6 comments
19,817 views