Lock Row of a Table using SQL

How to lock a particular row of a table using SQL?

Showing Answers 1 - 3 of 3 Answers

krishnaindia2007
Profile Answers by krishnaindia2007

Jun 20th, 2008

INSERT , UPDATE, DELETE operations implicity lock rows of a table that satisfies the condition.

Explicitly you may lock a table using for update of as follows

SELECT * FROM EMP
WHERE EMPNO = 7369
FOR UPDATE OF SAL NOWAIT

It will lock single row of emp table having employee number 7369.