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
Answers were Sorted based on User's Feedback
Answer / nidhi
yes For Loop will be faster than the open fetch loop
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
Answer / mihir kar
For loop is always faster than explicitly open -fetch loop.
the main advantages of for loop is it internally works like bulk collect limit 100
it hold 100 record and fetch so it is always preferebale.
Is This Answer Correct ? | 0 Yes | 0 No |
What is an Exception ? What are types of Exception ?
What is oracle sql developer?
How can triggers be used for the table auditing?
what is a relationship and what are they? : Sql dba
How do sql triggers work?
Write the order of precedence for validation of a column in a table ?
what is transaction? : Sql dba
What are the advantages of sql?
What is primary key in db?
Is sql microsoft?
how will you find out the last three records in a table with n no of records and delete them
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba