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!

recording a last updated time for each record in a table

784721Nov 26 2010 — edited Nov 26 2010

hi

i have a table with 5 columns. and the table has 100 rows of data.
i need to add a sixth column and this column should contain the last updated time of that particular row.
i am allowed to use triggers.

for example, if the 55th row undergoes a change, the 6th column's value for the 55th row should update itself with that particular time.

can any one of you come up with an optimized solution for this please ???

thanx a million in advance and best regards,
novice DBA
:)

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 24 2010

Added on Nov 26 2010

#table, #update

5 comments

1,284 views