Can you use a select query in a loop to fetch multiple rows?
If so what is the advantage of using a cursor?
Answer Posted / satheesh reddi
no...for that we are using cursors. due to cursors we can retrieve or fetch number of rows at a time from the table
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is dbrm in db2 database?
B37 abend during spufi?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What is a db2 package?
What is check constraint in db2?
What is innodb buffer pool?
Why do chiropractors use drop table?
What is difference between alias and synonym in db2?
What r the comman abends in db2, jcl and cobol???????
What is db2 bind process?
What is the use of runstats in db2?
How to find the number of rows in db2 tables?
what is the sqlcode -501
What is nvl in db2?
What is a db2 cursor?