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...

difference between For each and for all

Answer Posted / shishir

For each will process the statements for each row of the
bulk collect ,whereas for all will process all the records
in a single shot. These key work is generally used with the
bulk collections to enhance the preformance by minimizing
the I/O operations

Is This Answer Correct ?    5 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are snapshots? What are materialized views & where do we use them?

1043


How would you write a left join statement to return a result set of movie.title�s and director.name�s?

1029


How to get the first 100 rows from the flat file into the target?

1210


Explain what is a three tier data warehouse?

978


Explain if a flat file cotains 1000 records how can I get first and last records only?

933


Explain what are non-additive facts?

1033


Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?

971


What is prompt types of prompts?use of prompts syntax of prompt?

1348


What do you mean by static and local variable?

966


What is bi?

1099


Explain what is the difference between view filter and report filter?

982


Explain the data type of the surrogate key?

952


Explain what are the modules in power mart?

1051


Where we use surrogate key explain with example?

1136


What is a cube in data warehousing concept?

1077