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 |
What are tables in sql?
Is sql injection illegal?
How much does a sql dba make? : SQL DBA
How to add a column ‘salary’ to a table employee_details?
what are the advantages and disadvantages of cascading style sheets? : Sql dba
What is trigger explain it?
display records from 5 to 9 using rowid or rownum
How can you fetch first 5 characters of the string?
What operating systems are supported by oracle sql developer?
What does count (*) do in sql?
What is the basic structure of PL/SQL ?
What is cross join example?