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
- 8620 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 difference between inner and outer join? Explain with example. : Sql dba
When is the explicit cursor used ?
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
What is compound trigger?
What is t sql in sql server?
What is mdf ldf and ndf?
how to create a new table by selecting rows from another table in mysql? : Sql dba
What are different functions in sql?
How to take user input in pl sql?
What is sql indexing?
What is function and procedure?
What is the difference between a query and a report?
what is a database? : Sql dba
Which nosql database is best?
How many developers work on postgresql?
