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
- 8659 Views
- JDA, I also Faced
- E-Mail Answers
Answer Posted / swastik
yes for loop is faster tan loop-fetch
in loop there is exit statement to control the loop
in for loop it is an implicitly declared integer which is incremented or decremented by 1 until the upper bound or lower bound is reached
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the types of keys?
What are the qualities of 2nf?
How do I sort a table in sql?
What is dcl in sql?
What is difference between mysql and postgresql?
Is trigger a stored procedure?
what are the limitations of identity column? : Transact sql
Why we use triggers in mysql?
What do you understand by pl/sql packages?
What are the set operators in sql?
What is the process of copying data from table a to table b?
How is data stored in sql?
what is the difference between a web-garden and a web-farm? : Sql dba
Explain what is rdbms?
Define implicit and explicit cursors.
