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
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCA PL/SQL Developer
Oracle ACE Director
My website: www.oracle-base.com
My blog: www.oracle-base.com/blog