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 about rct.
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
Can we update view in db2?
what is the sqlcode -501
What is an instance in db2?
What is data manager?
What are the contents of a dclmgen?
What is an instance database?
What is a buffer in memory?
How connect db2 database to datastage?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
Why select is not preferred in embedded sql programs?
What does db2 blu stand for?
How can you find out the # of rows updated after an update statement?
How to resolve deadlock issue