difference between For each and for all

Answers were Sorted based on User's Feedback



difference between For each and for all..

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

difference between For each and for all..

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

Post New Answer

More Data Warehouse General Interview Questions

What is your spectra photometer working principles?

0 Answers  


Explain what are the various file formats involved in reportnet?

0 Answers  


What are templates in which way it is help full?

0 Answers  


What are the different methods of loading dimension tables?

0 Answers  


Explain datawarehousing?

0 Answers  






Explain what is cost benefit analysis (cba)?

0 Answers  


Explain what are the various transformation available?

0 Answers  


Explain some of modeling tools available in the market?

0 Answers  


What is factless fact tables?

0 Answers  


What is the advantages data mining over traditional approaches?

0 Answers  


Can we have more than one time dimensions in a Schema(Star or Snowflake)

1 Answers   ASD Lab, IBM,


What is a hash cluster?

0 Answers  


Categories