InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What A Select For Update Cursor Represent? |
|
Answer» 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. 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. |
|