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 difference between partitioning and sharding?
what are the nonstandard string types? : Sql dba
What is #table in sql?
What is the difference between jpql and sql?
Are dml statements autocommit?
what are the differences between require and include, include_once and require_once? : Sql dba
Why is pl sql needed?
Why do we use view in sql?
What are all the different normalization?
How to get list of all tables from a database?
What is the difference between a primary key and a clustered index?
Can we use pl sql in sql server?
Which are the different character-manipulation functions in sql?
What is the need of merge statement?
How do you identify a primary key?
