Row Level Locking in Oracle
In Oracle, the Undo records allow data that is being modified to be accessed. Oracle uses row level locking to prevent two processes from trying to update the same data at the same time. Only the rows being modified are locked. This means that the rest of the table can still be modified while a …