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
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
What are the string functions in sql?
What are the parameter modes supported by pl/sql?
Is sql between inclusive?
How many joins can you have in sql?
What is the location of pre_defined_functions.
Explain the select statement in sql?
How do I view output in sql developer?
How exception handling is done in advance pl/sql?
how to enter numeric values as hex numbers? : Sql dba
What is record data type?
What is a pl/sql block?
How to run pl sql program in mysql?
Is time a data type in sql?
How show all rows in sql?
