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
Is oracle an open source?
What is data block in Oracle?
How to start your 10g xe server?
Explain what are the characteristics of data files?
How to create a table interactively?
What is a partition in oracle?
How a tablespace is related to data files?
Briefly explain what is literal? Give an example where it can be used?
Explain oracle left join with an example?
How to convert characters to numbers in oracle?
What to do if the startbd.bat failed to start the xe instance?
What is oracle used for?
What are the various types of snapshots ?
What is the purpose of save points in oracle database?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....