Can you use a select query in a loop to fetch multiple rows?
If so what is the advantage of using a cursor?
- 2 Answers
- 4015 Views
- L&T, UST, I also Faced
- E-Mail Answers
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 db2? Explain.
What is difference between alias and synonym in db2?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What are packages in db2?
What is meant by explain?
How is the value function used?
What is the difference between bind and rebind in db2?
What is a dbrm in db2?
Explain db2.
Can you use max on a char column?
What is cloudant database?
What is commit in db2?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
Is it possible using max on a char column?
How to check last update on table in db2?
