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
- 8452 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
Where do we use pl sql?
How many joins in sql?
What is primary key secondary key alternate key candidate key?
what is the different between now() and current_date()? : Sql dba
how can you see all indexes defined for a table? : Sql dba
How do I audit the sql sent to the server?
Is oracle and sql same?
Is postgresql a nosql database?
Can we perform dml in function?
How do you bind variables in pl sql?
How do I add a database to sql?
What is the reports view in oracle sql developer?
Is sql considered coding?
What is latest version of sql?
What is difference between rank () row_number () and dense_rank () in sql?
