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
- 5919 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 difference between alias and synonym in db2?
What is the difference between drop table and delete table?
Why do we need reorg in db2?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
Define declaration generator (dclgen).
What is the difference between bind and rebind in db2?
What parameters are used to control the free space in DB2?
What is cascading rollback?
What is null in db2?
What is the difference between cursor stability and repeatable read isolation levels?
What is the difference between cursor and select statement?
Which command is used to remove all rows from a table?
Differentiate between cs and rr isolation levels? Where do you specify them?
Mention the definition of cobol in varchar field.
What is cloudant database?
