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 surrogate key?
How can you communicate with web server (apache or iis) from coldfusion?
What are the methodologies of data warehousing?
Difference between e-r modeling and dimentional modeling?
What we will do with the universe for faster process?
What are the different types of segments?
What are aggregate tables and aggregate fact tables?
Explain what is a cube in data warehousing concept?
What are loops in Datawarehousing?
Explain ddl (data definition language)?
What is the definition of cube in datawarehousing?
if we increase the number of dimensions will the rows in fact table increase or decrease??