What a SELECT FOR UPDATE cursor represent.?
Answer / 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 |
What is format trigger?
can you explain performance tunning in oracle(sql,PL/SQL)
can u call user defined functions in select statements
can we insert any row to dual table if i got the permission from DBA
What is translate in oracle?
What is dynamic proxy?
How to run queries on external tables?
definition of cluster and non-clustered index?
Explain the use of rows option in imp command.
What does sharding mean?
How to drop an existing table in oracle?
difference between oracle8i and oracle9i