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
- 7811 Views
- JDA, I also Faced
- E-Mail Answers
Answer Posted / mihir kar
For loop is always faster than explicitly open -fetch loop.
the main advantages of for loop is it internally works like bulk collect limit 100
it hold 100 record and fetch so it is always preferebale.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Show code of a cursor for loop.
What are the two virtual tables available at the time of database trigger execution?
How would you pass hints to the sql processor?
What is sql in oracle?
What is varray in pl sql?
What is synchronized subquery?
Is join an inner join?
What will you get by the cursor attribute sql%notfound?
What is the difference between in and between in sql?
How do I write a sql query in pgadmin 4?
How do I view a procedure in sql?
what is acid property in database? : Sql dba
What are the possible values that can be stored in a boolean data field?
How much does sqlite cost?
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
