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 the difference between olap and datawarehosue?
Explain the different types of data warehousing?
How to get the first 100 rows from the flat file into the target?
What is your spectra photometer working principles?
what are the all possible features supported modify stage?
What are the different types of scd's used in data warehousing?
What needs to be done while starting the database?
What is a ETL/ How does Oracle support the ETL process?
What is Analysis Services?
What are the advantages of cold fusion?
What is the data type of the surrogate key?
Where the applications and where