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 are the two types of periodical indexes?
How do you optimize a stored procedure in sql?
What is the non-clustered index in sql?
what is self-join? : Sql dba
What is the difference between alter trigger and drop trigger statements?
What are the most important characteristics of pl/sql?
What are the different types of sql commands?
What are local and global variables and their differences?
how do you know if your mysql server is alive? : Sql dba
Explain how can you save or place your msg in a table?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
What is the command used to fetch first 5 characters of the string?
Is sql a programming?
What are all the different normalizations?
How many types of privileges are available in sql?
