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
- 4 Answers
- 7807 Views
- JDA, I also Faced
- E-Mail Answers
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 many aggregate functions are available there in sql?
How to take user input in pl sql?
What are literals in sql server?
describe mysql connection using mysql binary. : Sql dba
What is normalization in a database?
How do I run sql?
Is natural join and inner join same?
How can I get the number of records affected by a stored procedure?
Why left join is used in sql?
How to run sql statements with oracle sql developer?
what is the difference between inner and outer join? Explain with example. : Sql dba
How exception is different from error?
what are date and time intervals? : Sql dba
What is cold data?
How can use stored procedures in sql?
