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
Explain what is dbms?
What is keys and its types?
What is an inner join sql?
What port does sql server use?
What is a database? Explain
What is %rowtype in pl sql?
What is where clause in sql?
What is the default isolation level in sql server? : Transact sql
What is a primary key sql?
What are dml commands?
How to write pl sql program in mysql command prompt?
What are the types of subqueries?
Which is faster subquery or join?
What are crud methods?
What is pessimistic concurrency control? : Transact sql
