Open Cursors

If you have an open cursor on a table, modify the same table and commit, what would happen?

Questions by ranjith12

Showing Answers 1 - 6 of 6 Answers

joshmohit

  • Oct 23rd, 2010
 

To provide read consistency, the same records as per when the cursor was opened will be used till the cursor is closed.

  Was this answer useful?  Yes

KSPradeep Rayavarapu

  • Jan 28th, 2013
 

changes will save..

tinku981

  • Jun 14th, 2013
 

There will not be any impact on the output even if we will insert (and commit) the data after cursor is opened. The output will be same as of the record set when cursor was opened and new row will not be selected in that operations.

For example, before and after running below code the output was following

  Was this answer useful?  Yes

tinku981

  • Jun 14th, 2013
 

There will not be any impact on the output even if we will insert (and commit) the data after cursor is opened. The output will be same as of the record set when cursor was opened and new row will not be selected in that operations.

  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