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
Which is faster joins or subqueries?
Is postgresql a nosql database?
What is rank dense_rank and partition in sql?
what happens if null values are involved in expressions? : Sql dba
Explain what is a column in a table?
Is left join faster than join?
What does joining a thread mean?
Is stored procedure faster than query?
How can you tell the difference between an index and a view?
how to start mysql server? : Sql dba
What is 19 null in sql?
Explain the difference between triggers and constraints?
How to change sql*plus system settings?
What is left join example?
What is the usage of when clause in trigger?