Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

How to check last update on table in db2?

1001


What is runstats and reorg in db2?

1236


What do you mean by storage group (stogroup)?

984


What are the prerogatives?

1014


What is with ur in db2?

1242


How to find schema of a table in db2?

951


What is the cobol picture clause of the db2 data types date, time, timestamp?

1008


What is the role of the data page in the db2 database?

972


How to execute stored procedure in db2 command editor?

984


What is db2 stogroup?

1095


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.

3144


Mention some fields that are a part of sqlca.

969


What is a cursor in programming?

1013


What is the information associated with sysibm.syslinks table?

1055


What does a deadlock mean in DB2?

1094