Answer Posted / guru
A DML statement can transfer all the elements of a
collection in a single operation, a process known as bulk
binding. If the collection has 20 elements, bulk binding
lets you perform the equivalent of 20 SELECT, INSERT,
UPDATE, or DELETE statements using a single operation. This
technique improves performance by minimizing the number of
context switches between the PL/SQL and SQL engines. With
bulk binds, entire collections, not just individual
elements, are passed back and forth.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What is the use of non clustered index?
What is right join sql?
Is full outer join same as cross join?
How do I find duplicates in the same column?
What is a trigger word?
How do I view a sql database?
what is innodb? : Sql dba
Define tables and fields in a database
What are the advantages of indexing?
What is bitemporal narrowing?
What is java sql connection?
What is sql*plus?
how many ways we can we find the current date using mysql? : Sql dba
Does group by remove duplicates?
What do you mean by dbms? What are its different types?
