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
- 8627 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 is mutating error?
How do I create an index in word?
What is sqlerrm?
How many types of keys are there in sql?
Is a foreign key always unique?
what are dynamic queries in t-sql? : Transact sql
How can we store rows in PL/SQL using array?
How many rows can sqlite handle?
Explain mutating table error.
What is a procedure in pl sql?
What is prepared statement in sql?
what is “go” in t-sql? : Transact sql
what are the authentication modes in sql server? How can it be changed? : Sql dba
What is the difference between alter trigger and drop trigger statements?
How run sql*plus commands that are stored in a local file?
