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
- 8455 Views
- JDA, I also Faced
- E-Mail Answers
Answer Posted / nidhi
yes For Loop will be faster than the open fetch loop
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Which is better stored procedure or query?
Which is better join or subquery?
What is recursive join in sql?
What happens when a trigger is associated to a view?
what is single byte over head in oracle..?
What is asqueryable?
What are the two types of periodical indexes?
How show all rows in sql?
What are sql commands?
How to add new employee details in an employee_details table with the following details
Is sql database free?
What types of commands can be executed in sql*plus?
What are predefined functions in sql?
What are the most important characteristics of pl/sql?
What is an invalid partition table?
