Answer Posted / nishi
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.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why we use bulk collect in oracle?
How to delete a user account in oracle?
How to use "in" parameter properly?
What do you mean by merge in oracle and how can you merge two tables?
What is a cursor and what are the steps need to be taken?
What is the usage of save points in oracle database?
what are the advantages of running a database in archive log mode?
How to create a table index in oracle?
How will you write a query to get a 5th rank student from a table student_report?
How to drop an index in oracle?
What is literal?
What is meant by an index?
Hi Can any one tell me what are the API's used in requisition import.
What privilege is needed for a user to delete rows from tables in another schema?
What is a nvl function?