DEVFYI - Developer Resource - FYI

What a SELECT FOR UPDATE cursor represent.?

ORACLE Interview Questions and Answers (Part 3)


(Continued from previous question...)

523. What a SELECT FOR UPDATE cursor represent.?

SELECT......FROM......FOR......UPDATE[OF column-reference][NOWAIT]
The processing done in a fetch loop modifies the rows that have been retrieved by the cursor. A convenient way of modifying the rows is done by a method with two parts: the FOR UPDATE clause in the cursor declaration, WHERE CURRENT OF CLAUSE in an UPDATE or declaration statement.

(Continued on next question...)

Other Interview Questions