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
Explain what are the various isolation levels possible?
On which levels locks can be applied?
What is precompiler in db2?
How to create backup table in db2?
What is the result of open cursor statement?
How to create db2 table in mainframe?
can we view the access paths created by dbrm ? how ? thx
How can we retrieve the total number of records in RPG & CLLE?
What is a db2 table?
Comment whether the cursor is closed during commit or not.
What is dbrm? What it contains? When it will be created?
Can we delete records from view?
What db2 400?
What are db2 tables?
Define db2 and its databases?