Created and Last updated IDs
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?
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.
If you want something "out of the box", I guess the best option is to use Auditing, specifically Fine Grained Auditing (FGA):
Then again, there is nothing wrong with the previous suggestion. I use it myself on occasion
Click Here to Expand Forum to Full Width