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 are the arithmetic operations?
List the various oracle database objects?
What is java oracle used for?
How to start a new transaction in oracle?
Query to retrieve record for a many to many relationship ?
What is flashback in Oracle?
What is hash cluster in oracle?
What is self-referential integrity constraint ?
What are the differences between date and timestamp in oracle?
How can we force the database to use the user specified rollback segment?
How to export your own schema?
how to use sequence and what use of sequence cache