Interested to Buy Any Domain ? << Click Here >> for more details...
What a SELECT FOR UPDATE cursor represent.?
- 1 Answers
- 2823 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 |
How can I get column names from a table in oracle?
How to use like conditions in oracle?
What are the different windows events activated at runtime ?
What is a database table in oracle?
Is there a function to split a string in plsql?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?
how to hide the stored procedure inside a package
What are various joins used while writing SUBQUERIES?
How to use "out" parameter properly?
query to find the maximum no persons with same age(age colomn) from emp table
What is the disadvantage of User defind function?
Oracle General 
