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
Answer Posted / nidhi
yes For Loop will be faster than the open fetch loop
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
Is oracel sql developer written in java?
How is pl sql different from sql?
What is spool?
What are inbuilt functions in sql?
How many sql commands are there?
What is schema in sql example?
Why is pl sql needed?
How do you remove duplicates without using distinct in sql?
How does sql store data?
What is latest version of sql?
Can unique keys be null?
Explain sql data types?
What is difference between function and trigger?
What is pl sql package?