Created and Last updated IDs

[sureshamathew]

Hi,

Does Oracle have any function which can help me keep track of whose has inserted(created) a row and whose has updated the same row latest?
Uptill now, I am doing it via a bit of coding, but are there any functions which help me do the same?

Suresh

[thomasp]

You could have a date stamp field in the table and a trigger to update this field each time any data manipulation like insert or update is done.

[TimHall]

If you want something "out of the box", I guess the best option is to use Auditing, specifically Fine Grained Auditing (FGA):

http://www.oracle-base.com/articles/...ained_auditing

Then again, there is nothing wrong with the previous suggestion. I use it myself on occasion

Cheers

Tim...