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
- 8585 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
What is the use of triggers?
How do I truncate a word?
how is myisam table stored? : Sql dba
What is ttitle and btitle?
Why do we use view in sql?
What is character functions?
Why we use join in sql?
Is big data nosql?
What is oracle sql called?
What are sql objects?
Can a foreign key be a duplicate?
How can you fetch common records from two tables?
Can we enter data in a table in design view?
What is online transaction processing (oltp)?
What is foreign key sql?
