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
What is trigger types in sql?
how to concatenate two character strings? : Sql dba
How do you declare a constant?
what are sequences
What does trigger mean in slang?
what are the difference between clustered and a non-clustered index? : Sql dba
What is structural independence and why is it important?
What are the benefits of stored procedures?
What is the maximum database size for sql express?
What is data modelling in sql?
How do I delete a trigger?
What is primary key and unique key?
Can a composite key be null?
Why are sql stored procedures used?
What is primary key in db?