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
|