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
- 7129 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
Mention what does plv msg allows you to do?
How to install oracle sql developer?
How to connect a sql*plus session to an oracle server?
How does rowid help in running a query faster?
Is sql a microsoft product?
What are the possible values that can be stored in a boolean data field?
Does pl sql work in mysql?
What are all ddl commands?
What does closing a cursor do?
What is aggregate function in sql?
How to fetch alternate records from a table?
What are pl sql data types?
What is difference sql and mysql?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
Is oracle sql free?
