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?
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 maximum size of a char data type in db2?
What is meant by dclgen?
What is cloudant database?
Explain the contention situations caused by locks?
What is cursor stability in db2?
If I have a view which is a join of two or more tables, can this view be updateable?
What is db2 look?
What do you mean by storage group (stogroup)?
What is phantom read in db2?
What is dbrm in db2 database?
What are catalog tables in db2?
What is a buffer in memory?
What is host variable in db2 cobol?
How to rename a table in DB2 ?
What is the meaning concurrency in the db2 database?