Interested to Buy Any Domain ? << Click Here >> for more details...
difference between For each and for all
- 2 Answers
- 9284 Views
- I also Faced
- E-Mail Answers
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 are the advantages of cold fusion?
Select * from emp,dept,loc where emp.deptno left outer join dept.deptno and dept.locno=loc.locno. No need to consider the syntax but is it possible to have left outer join and equi join in the same SQL like this ? can we have right outer join and left outer join in the same SQL ---
1 Answers Principal Finance, PT Metalogix Infolink Persada,
What is cost benefit analysis (cba)?
What is defined as partial backup?
Explain difference between e-r modeling and dimentional modeling?
I need to set predefined condition. How I do this?
in general which algorithms for used?
How to provide security in frame work manager for a query subject?
Explain what is power center repository?
What does level of granularity of a fact table signify?
What are the possible data marts in retail sales?
Explain the difference between data ware house & data mart?
Teradata 
