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
What are the different editions of oracle?
Explain about your project and its relation to the current job position you are applying to?
How to assign values to data fields in record variables?
Calculate difference between 2 date / times in oracle sql?
What are operators in oracle?
Is there a function to split a string in plsql?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
What is the difference between substr and instr?
What are the differences between blob and clob in oracle?
What is a tns service name?
Compare and contrast between sql and sql server and explain its various functions?
What are the common oracle dba tasks?
Which are the five query types available in oracle?
How different is ms access and oracle?
What is the usage of analyze command in oracle?