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 difference between normal select query and
currosor

Answer Posted / vinay srivastava

Normal select Query fetches all rows in one go while cursor
fetches one row at a time.

Is This Answer Correct ?    10 Yes 17 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the role of schema in the db2 database?

1357


Explain about open switch business continuity software?

1180


I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

2108


What is the difference between spufi and qmf?

1200


What is db2?

1228


What is catalog database in db2?

1212


What does sqlcabc has?

1093


Explain correlated sub-queries.

1091


What is the difference between bind and rebind in db2?

1505


SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11740


How to find schema of a table in db2?

1062


List out the data types available.

1199


How do I change the column size in db2?

1205


How to retrieve rows from a db2 table in embedded sql?

1438


Why db2 is called db2?

1105