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
How to get the first 100 rows from the flat file into the target?
How to calculate fact table granularity?
Explain clustering algorithm?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....
Which component has onread method and what it is used for?
What are modeling tools available in the market?
What is edw?
Explain is fact table?
What are the methodologies of data warehousing?
what are the others of "bad files" and "discard files" when using sql*loader?
If two relational tables are connected to sq trans, what are the possible errors it will be thrown?
for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?
What is a view as it relates to system modeling?
What is ods (operation data source)?