Interested to Buy Any Domain ? << Click Here >> for more details...
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
Enlist the characteristics of pl/sql?
What is left join in sql?
What is procedure explain with program?
How many rows can sqlite handle?
what are the properties and different types of sub-queries? : Sql dba
What are all the different types of indexes?
What is the difference between sum and count in sql?
How do you identify a primary key?
Can we use distinct and group by together?
What are string functions in sql?
Can we insert data into materialized view?
Can you join a table to itself?
What is memory optimized table?
What are stored procedures used for?
What is set transaction?
