Interested to Buy Any Domain ? << Click Here >> for more details...
In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both loops can do the same task)
1) open - Fetch loop
2) for loop
- 4 Answers
- 8583 Views
- JDA, I also Faced
- E-Mail Answers
Answer Posted / monika
for loop is faster then open -fetch loop
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are the types of variables use in pl sql?
What are stuff and replace function?
What is sql profiling in oracle?
How do I filter in sql profiler?
When you have to use a default "rollback to" savepoint of plvlog?
What is function and procedure in pl sql?
What is meant by temporal data?
Why query optimization is needed?
How do you update a table in sql?
What is an alias command?
What is difference between group by and partition by?
What is count * in sql?
What is Histogram?
What is the reports view in oracle sql developer?
What is trigger and stored procedure in sql?
