Interested to Buy Any Domain ? << Click Here >> for more details...
What happens to a cursor after a commit?
- 3 Answers
- 9958 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / angoca
The commit will close the cursor if this last was not
declared with the 'with hold' option.
| Is This Answer Correct ? | 14 Yes | 0 No |
If the cursor is defined with "WITH HOLD" option, it will NOT closed even after the commit operation, else cursor will be closed.
| Is This Answer Correct ? | 0 Yes | 0 No |
What can the SET option of the Repair Utility accomplish?
Explain what are the various isolation levels possible?
What are the various locks available?
what are the bind parameters?
in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....
suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?
difference between group clause and order clause
How can you display the current date & current time ?
Outputs of explain are with matchcols = 0. What does this signify?
Can we update view in db2?
What is db2 isolation?
Once you create a view, where would information about the view be stored?
COBOL 
