What is the purpose of coding FETCH in a SQL SELECT query?
Explain with an example in Detail?
Answer Posted / guest
FETCH is used to retrieve a specific row from a result set
of the SELECT query and places them into local variables.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to access db2 tables in mainframe?
What is dbrm? What it contains? When it will be created?
How will you return the number of records in table?
What is consistency token in db2?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
Which component is used to execute the sql statements?
What are union and union all?
What do you mean by commit and rollback?
Discuss about db2 bind?
How would you find out the total number of rows in a db2 table?
What is the use of dclgen in db2?
What is a db2 table?
What is the maximum No of rows per page?
What is universal database?
Define sqlca.