How to avoid using cursors? What to use instead of cursor and in what cases to do so?
- 1 Answers
- 1277 Views
- I also Faced
- E-Mail Answers
Answer Posted / Umesh Kumar Jaiswal
To avoid using cursors, you can utilize collection types such as arrays or tables. These methods are more efficient for large datasets. Instead of a cursor loop, you might employ a Bulk Collect operation to reduce the number of round trips between PL/SQL and the database. This technique is particularly useful when dealing with multiple rows at once. However, it's essential to consider the complexity of your code and the size of your dataset when deciding whether to use cursors or collections.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is primary key always clustered index?
how to start mysql server? : Sql dba
What is your daily office routine?
Is primary key clustered index?
what is sql server agent? : Sql dba
What is the current version of sql?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
how many tables will create when we create table, what are they? : Sql dba
what are aggregate and scalar functions? : Sql dba
Do we need to rebuild index after truncate?
how to escape special characters in sql statements? : Sql dba
what is collation? : Sql dba
what is dbms? : Sql dba
how to use regular expression in pattern match conditions? : Sql dba
Does group by remove duplicates?
