difference between For each and for all

Question Posted / guest

2 Answers
9403 Views
I also Faced
E-Mail Answers

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 are the others of "bad files" and "discard files" when using sql*loader?

0 Answers

Business rule implemntation depends on? 1.)ETL requiremnts 2.)ETL performance 3.)business requirements.

4 Answers

what is data validation strategies for data mart validation after loading process

1 Answers

Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?

0 Answers

what role views play in dimensional modeling?

1 Answers TCS, Zensar,

What is the difference between Datawarehouse and OLAP?

0 Answers

What are the stages of datawarehousing?

0 Answers

Tell me one example for junk dimension?

9 Answers TCS,

What is a hash cluster?

0 Answers

Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?