Answer Posted / 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 View All Answers
What are snapshots? What are materialized views & where do we use them?
How would you write a left join statement to return a result set of movie.title�s and director.name�s?
How to get the first 100 rows from the flat file into the target?
Explain what is a three tier data warehouse?
Explain if a flat file cotains 1000 records how can I get first and last records only?
Explain what are non-additive facts?
Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?
What is prompt types of prompts?use of prompts syntax of prompt?
What do you mean by static and local variable?
What is bi?
Explain what is the difference between view filter and report filter?
Explain the data type of the surrogate key?
Explain what are the modules in power mart?
Where we use surrogate key explain with example?
What is a cube in data warehousing concept?