Which clause is used to lock a row containing a LOB, while the row is locked and other users cannot able to unlock or update the LOB, until you end your transaction?

Options
- FOR EACH clause
- UPDATE clause
- FOR UPDATE clause
- LOCK ROW

CORRECT ANSWER : FOR UPDATE clause

Discussion Board
FOR UPDATE Clause

FOR UPDATE clause is used to lock a row containing a LOB, while the row is locked and other users cannot able to unlock or update the LOB, until you end your transaction. The FOR UPDATE clause is an optional part of a SELECT statement. Cursors are read-only by default. The FOR UPDATE clause specifies that the cursor should be updatable, and enforces a check during compilation that the SELECT statement meets the requirements for an updatable cursor.

Prajakta Pandit 02-27-2017 01:25 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲