What is the significance of the cursor with hold clause in a cursor declaration?

The clause avoids closing the cursor and repositioning it to the last row processed when the cursor is reopened.
  • Interview Candidate
  • 3
  • 2832

Showing Answers 1 - 3 of 3 Answers

prasenjit_in

  • Jul 18th, 2008
 

To explain it let us take an example....

Suppose we have a query that updates a table once the task is complete the table gets updated(commit), and all the relevant resources acquired by the task is released..With hold option does not release the resouces once it encounters the commit statement so that even after the execution of the command the resouce are still with the program...

correct me if i am wrong

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions