Interested to Buy Any Domain ? << Click Here >> for more details...
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 is oracle database so popular?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
What are the extensions used by oracle reports?
How to create an oracle database manually?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
what is the dual table in oracle?
How to use subqueries in the from clause in oracle?
Explain self joins in oracle?
What is BBED in Oracle?
How to pass a parameter to a cursor in oracle?
What is the difference between postgresql and oracle?
Explain the use of rows option in imp command.
What are the parameters that we can pass through a stored procedure?
How to write a left outer join with the where clause in oracle?
What is oracle used for?
