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 / monika
for loop is faster then open -fetch loop
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is difference between sql function and stored procedure?
State few characteristics of pl/sql?
What is cursor and its types?
which operator is used in query for pattern matching? : Sql dba
Can we commit inside a trigger?
What is query execution plan in sql?
What are the 3 modes of parameter?
What is pl sql in oracle?
How to assign sql query results to pl sql variables?
Can we use pl sql in sql server?
Explain what is a column in a table?
Why self join is used in sql?
Define overloaded procedure?
How many times can we commit in a loop?
What is faster join or subquery?