What a SELECT FOR UPDATE cursor represent.?
- 1 Answers
- 2196 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 |
Explain the different normalization forms?
How to initialize variables with default values?
What is a procedure in oracle?
Explain oracle 12c new features for developers?
What is the difference between "as" and "is" in an oracle stored procedure?
how to do daily transactions with out sql* loader control file regesterd in apps?
What is the difference between hot backup and cold backup in oracle?
What is a lookup table in oracle?
What are the Limitations of a CHECK Constraint ?
How to find 1st, 2nd, 3rd highest using select select statement not using rownum
What are the different types of trigger and explain its various uses and functions?
What is meant by raw datatype?
Oracle General 
