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
- 8584 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
How to select random rows from a table?
What does pl sql developer do?
Why do we use cursors?
List out the acid properties and explain?
how to convert character strings to numeric values? : Sql dba
How to add new employee details in an employee_details table with the following details
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
Is sql scripting language?
What is the difference between view and stored procedure?
How many tables can you join in sql?
What is sql data?
what is heap table? : Sql dba
how many triggers are allowed in mysql table? : Sql dba
Why do we use sql constraints?
what is the difference between a local and a global temporary table? : Sql dba
