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
- 8780 Views
- JDA, I also Faced
- E-Mail Answers
Answer Posted / monika
for loop is faster then open -fetch loop
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
what are the types of subquery? : Sql dba
Why trigger is used in sql?
What is the most common sql injection tool?
how do you know if your mysql server is alive? : Sql dba
Which join condition can be specified using on clause?
What is the cause of mutating table error and how can we solve it?
What is the use of primary key?
What is thread join () in threading?
What is the difference between join and natural join?
What is a nested table in word?
what is the difference between undefined value and null value? : Sql dba
Can delete statement be rollbacked?
what is row? : Sql dba
What do you mean by stored procedures? How do we use it?
How many triggers can be applied to a table?
