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
Answers were Sorted based on User's Feedback
Answer / nidhi
yes For Loop will be faster than the open fetch loop
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / swastik
yes for loop is faster tan loop-fetch
in loop there is exit statement to control the loop
in for loop it is an implicitly declared integer which is incremented or decremented by 1 until the upper bound or lower bound is reached
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / mihir kar
For loop is always faster than explicitly open -fetch loop.
the main advantages of for loop is it internally works like bulk collect limit 100
it hold 100 record and fetch so it is always preferebale.
Is This Answer Correct ? | 0 Yes | 0 No |
How do I find duplicates in a single column in sql?
What is the difference between having clause and where clause?
what is difference between procedure and function
10 Answers MCN Solutions, Wipro,
What are the two characteristics of a primary key?
What does the sign mean in sql?
if i perform any operation on views such as insert, delete etc will my base table get affected?????
Does sql support programming?
what is outer join? what is selef join? what is difference between them? what is cartecion join?
1 Answers Fiserv, Herbinger, Synechron,
Is ms sql is free?
How do I start pl sql?
What are procedures used for?
Is a secondary key the same as a foreign key?