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
- 8631 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 is $$ in sql?
Is sql difficult?
What is the use of procedures?
What are sql objects?
Explain how exception handling is done in advance pl/sql?
What has stored procedures in sql and how we can use it?
Explain spool.
What does the argument [or replace] do?
What is the least restrictive isolation level? : Transact sql
How do I run sql?
what are the nonstandard string types? : Sql dba
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
How do you bind variables in pl sql?
how many triggers are allowed in mysql table? : Sql dba
how many ways we can we find the current date using mysql? : Sql dba
