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
- 8454 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
Is t sql a programming language?
What is sql and how does it work?
List different type of expressions with the example.
how to drop an existing table in mysql? : Sql dba
Is there any restriction on the use of union in embedded sql?
What are %type and %rowtype for?
What are conditional predicates?
what is online transaction processing (oltp)? : Sql dba
What is varchar data type in sql?
what is myisam? : Sql dba
what is view? : Sql dba
What is the difference between the conventional and direct path loads? : aql loader
How do I run a script in sql developer?
Explain scalar functions in sql?
How many tables can a sql database have?
