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
- 7471 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
Define predicate?
Explain about rct.
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is consistency token in db2?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What are the various data types available in db2?
Define data page.
What is image copy in db2?
How to find the number of rows in db2 tables?
How to find primary key of a table in db2?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
If I have a view which is a join of two or more tables, can this view be updateable?
What is the syntax for FETCH in DB2 ?
How to retrieve rows from a db2 table in embedded sql?
What is null indicator in db2?
