Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between normal select query and
currosor
- 2 Answers
- 17318 Views
- Cap Gemini, TCS, I also Faced
- E-Mail Answers
Answer Posted / jagan
using select in embedded sql with where clause should fetch
only one row , but cursor can be used when we need more rows
to be retrieved one at a time.
In case more than one row is retrieved in a select clause it
will throw -811 sql error.
| Is This Answer Correct ? | 28 Yes | 5 No |
Post New Answer View All Answers
How to view db2 table structure?
Explain package in db2 and its advantages?
What is the maximum size of a char data type in db2?
How will you return the number of records in table?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
Which are the db2 tools to protect integrity of the database?
Can one database have multiple instances?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
Describe major components of db2?
Is db2 free?
How to retrieve rows from a db2 table in embedded sql?
What are the various isolation levels possible?
What is runstats utility in db2?
Which is faster delete or truncate?
