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 inner join in sql?
What is a delimiter in sas?
How do you delete duplicates in sql query using rowid?
Do foreign keys improve performance?
Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)
How do I order by ascending in sql?
Is trigger a stored procedure?
What is vector point function?
What is the difference between distinct and unique in sql?
Why use triggers in sql?
What is a ddl command?
Is postgresql a nosql database?
Explain the the delete statements in sql?
Explain the order of sql statement execution?
How can you get sql*loader to commit only at the end of the load file? : aql loader