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
How do we specify index to include or not during bind process.
What is nvl in db2?
If I have a view which is a join of two or more tables, can this view be updateable?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is a page in db2?
What is alias in db2?
How does a cursor work?
What is syscat in db2?
What is null indicator in db2?
List out the data types available.
What is cloudant database?
Explain about rct.
What is temporal table in db2?
How to restart a DB2 program?
What does db2 blu stand for?