Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8664 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
What is delimiter sql?
How to create a menu in sqlplus or pl/sql?
Why do we use view in sql?
What is trigger in flip flop?
What operators deal with null?
What does the sign mean in sql?
Does user triggers have entry for trigger with compilation errors?
What is materialized view. What are different methods of refresh?
What is sql and also describe types of sql statements?
What is a primary key called that is made up of more than one field?
What do you know by pl/sql cursors?
Why is pl sql needed?
what are date and time intervals? : Sql dba
How do you declare a constant?
What is sql lookup?
