What a SELECT FOR UPDATE cursor represent.?
- 1 Answers
- 2480 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 analyze command ? what kind of statistics does it generate?
Differnce between view and index
Explain the use of online redo log files in oracle.
what are views?
how to store only time in a data base table
What is SQL access advisor in Oracle?
Can the query output be sorted by multiple columns in oracle?
How to define a record variable to store a table row?
What are the most common interview questions on ETL Testing for experience?
How can you Enforce Referential Integrity in snapshots ?
Explain the difference between a procedure and a function?
how to retrive xml data for using sql query?
Oracle General 
