Thanks Tom, My apologies, its pseudo code and not exact 'update' statement. I agree that it's not deadlock and my understanding is that they have written this code segment to avoid deadlock scenario and enforcing control using repeat loop to obtain the record on exclusive-lock mode. If session-2...