What a SELECT FOR UPDATE cursor represent.?
- 1 Answers
- 2216 Views
- I also Faced
- E-Mail Answers
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 a deadlock ? Explain .
can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
what is RAID technology?which is better RAID 0+1 OR RAID 5?
Is rowid unique in oracle?
Design database draw er diagram for a certain scenario ?
0 Answers Keane India Ltd, TATA,
Where is the export dump file located?
How to assign query results to variables?
What is an oracle?
What are a collation and state the different types of collation sensitivity?
What is an oracle table?
What is Row Chaining ?
Oracle General 
