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

Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?

850


Where do we use semi and non additive facts?

935


explain about balanced dimension,

915


Explain difference between view and materialized view?

891


How to provide security in frame work manager for a query subject?

904


What is critical column?

1109


Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

901


What is the difference between er modeling and dimensional modeling?

1073


How to create different types of templates?

925


What is Active Datawarehousing?

951


Explain what is a staging area? Do we need it? What is the purpose of a staging area?

901


What is the difference between agglomerative and divisive hierarchical clustering?

1108


Why facts table is useful in representing the data?

929


Why we use repository connectivity?

922


Explain meta data?

954