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
- 8776 Views
- JDA, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
what is the bond code in materialized view?
How global cursor can be declare with dynamic trigger ?
how to use regular expression in pattern match conditions? : Sql dba
define data blocks ? : Sql dba
What is nvarchar in sql?
How would you reference column values before and after you have inserted and deleted triggers?
What does select * from mean in sql?
What is sql trigger example?
How to get unique records from a table?
how to show all tables with 'mysql'? : Sql dba
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
What is database sql?
What does trigger mean in slang?
What is orm in sql?
Is sql workbench free?
