Interested to Buy Any Domain ? << Click Here >> for more details...
Hi , I am posting some interview ques .
what is the use of cursors ? what is the diff between
select and cursor ? bith are used for data retrival ..
rite?
- 2 Answers
- 7306 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / yuvaevergreen
>>Cursors are memory structures used to handle multiple
rows at a time.
>>Though,select statement can fetch only multiple rows, we
cannot handle multiple rows using host variables.
Basic difference would be single row handling and multiple
rows handling.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
what is the role of the cursor in db2?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
How do I delete a table in database?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
How to find schema of a table in db2?
What is difference between isnull and coalesce?
Are view updateable?
What is clone table?
what is a corelated subquerry?
How can the duplicate values be eliminated from db2 select?
How many databases can be created inside an instance in db2 ?
What is a Foreign Key?
Differentiate between cs and rr isolation levels? Where do you specify them?
What is the latest version of ibm db2?
How do I create a view in db2?
