difference between For each and for all
Answers were Sorted based on User's Feedback
Answer / manshul goel
FOR EACH is considered as a "group by" in the SQL generated
while when we apply FOR ALL it generates SUMMARY on the
basis of the element
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
What is your spectra photometer working principles?
Explain what are the various file formats involved in reportnet?
What are templates in which way it is help full?
What are the different methods of loading dimension tables?
Explain datawarehousing?
Explain what is cost benefit analysis (cba)?
Explain what are the various transformation available?
Explain some of modeling tools available in the market?
What is factless fact tables?
What is the advantages data mining over traditional approaches?
Can we have more than one time dimensions in a Schema(Star or Snowflake)
What is a hash cluster?