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
- 8678 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 operating systems are supported by oracle sql developer?
What type of join is sql join?
what are the differences among rownum, rank and dense_rank? : Sql dba
what is the use of friend function? : Sql dba
Is primary key an index?
what is a cursor? : Sql dba
Is join and inner join the same?
Which is faster joins or subqueries?
what is 'mysqladmin' in mysql? : Sql dba
how do you login to mysql using unix shell? : Sql dba
Which sql statement is used to delete data from a database?
What is the maximum number of triggers, you can apply on a single table?
Is a secondary key the same as a foreign key?
What is the difference between truncate and drop statements?
What are the packages in pl sql?
