Answer Posted / yaswanth
we will use cursors when we have situation like the query
returning multiple rows but in this case
select Count(*) from EMP table where EMPNAME='some' will
return only one row, i.e how many rows it found with
EMPNAME='some' eg:3 or 4 or 5 ... so there is no concept of
cursor here
| Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
What does reorg do in db2?
What is db2?
Explain about mirror activator disk mirroring?
What is the difference between oracle and db2?
What are union and union all?
How to create backup table in db2?
What is the use of db2 optimizer?
How do you eliminate duplicate values in db2?
What is the physical storage length of timestamp data type?
Explain dclgen.
How to create db2 table in mainframe?
What are db2 objects?
What is db2 stogroup?
What is the difference between plan and package in db2?
How to rename a table in DB2 ?