Oracle Database Discussions

Hi,

I have been asked to develop an application where a single row from a table will be accessed by multiple users. Even multiple users can try to update the same row at the same time. So, to provide a solution of this problem should it be the best way to lock that particular row when user requesting to update it and after completion of commit the lock will be released. In the same time if some other user request to update the same row then it will be in the wait condition.

Please provide suggestion that is it the best way to handle the situation or not. If it is then can you also please provide an example (with sample code) of it.

Regards,
Koushik