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
What is on delete set null?
How do you explain an index number?
Which query operators in sql is used for pattern matching?
What is dml and ddl?
What are the two types of periodical indexes?
What are packages in pl sql and also explain its advantages?
what is 'mysqladmin' in mysql? : Sql dba
What is bind variable in pl sql?
What is pls_integer in pl sql?
What is fmtonly in sql?
Determine if oracle date is on a weekend?
Can unique keys be null?
what are the type of locks ? : Sql dba
How can use stored procedures in sql?
Define overloaded procedure?
