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 |
difference between oracle 8i and oracle 9i
What if we write return in procedure?
differentiate between float and double. : Sql dba
How do you remove duplicates without using distinct in sql?
Do ddl statements need commit?
Define sql delete statement.
Why do we use sql constraints? Which constraints we can use while creating database in sql?
Explain the rollback statement?
Why procedure is used in sql?
What does desc stand for?
How do you select unique values in sql?
What does the hierarchical profiler does?