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
- 6306 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 maximum size of varchar data type in db2?
What is bind in db2?
Explain db2.
Which command is used to connect to a database in DB2 ? Give the Syntax.
Which is faster delete or truncate?
What is a system catalog table in db2?
What happens in bind step in a db2 program?
What is ibm db2 client?
What are the benefits of using the db2 database?
Before you give the explain statement, what are the prerogatives?
What is load utility in db2?
What is the role of schema in the db2 database?
What is netezza database?
Explain the contention situations caused by locks?
What is the use of runstats in db2?
