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
- 5918 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / reddy
cursors are used to retrieve multiple rows . Cussors will
retrieve one row at a time and save the data in the
hostvariables.For retreiving the 2 nd row, we need to
repeat the loop.the same process is continued at the end of
data.
select stmt will retrieve multiple rows at a time. assume
that there are 10 rows in a table.
EX: EXEC SQL
SELECT empno , ename into :hvempno ,:hvename from emp;
END EXEC;
Here the above sql query reults all the 10 rows. But , the
host variables will hold only one row of data.the remaining
9 rows will not be stored any where.
hope this may help u
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
Explain about mirror activator disk mirroring?
Are view updateable?
What is phantom read in db2?
What is null indicator in cobol db2?
What is the maximum size of varchar data type in db2?
What is a dbrm in db2?
what is the responsibility of the construction superintendent
Why do we need reorg in db2?
What are host variables in db2?
What is universal database?
What are the full forms of spufi and dclgen and why are they used?
How can you do the explain of a dynamic sql statement?
Which isolation level provides highest data integrity?
How do I delete a table in database?
What is reorg?
