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
- 5568 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 explain in db2?
What is the purpose of using commit?
Name the lockable units in DB2?
Mention the downsides of page level lock.
What are the contents of dclgen?
What is blu acceleration in db2?
What is a page in db2?
What are host variables in db2?
What is the connection string to connect to the DB2 Database ?
When reorg is used?
Explain the contents that are a part of dclgen.
How to fetch the last row from the table in SQL (db2)?
What is the cobol picture clause of the db2 data types date, time, timestamp?
Before you give the explain statement, what are the prerogatives?
How many databases can be created inside an instance in db2 ?
