what is bulk bind
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 24/07/07
Bulk Bind is technique where instead of multiple individual
SELECT, INSERT, UPDATEE & DELETE statements are executed to
retrive from or store data in, at table all of the
opeartions are carried out at once in bulk.
Regard's
Srinivas Ganamur
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / roopesh kumar
Bulk binding is a way for performance tunning i.e. it will
complete the whole process in once remove the contaxt
switching of sql to pl-sql & pl-sql to sql.
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / suresh somayajula
Binding of entire collection at once is called as " Bulk
Bind".
Is This Answer Correct ? | 0 Yes | 1 No |
Why use stored procedures?
Can a key be both primary and foreign?
what happens if null values are involved in expressions? : Sql dba
What is keys and its types?
Is sql an operating system?
How to process query result in pl/sql?
how to find the First and Last Observation from the table: Ex: OBS Name Sal Ans like: OBS Name Sal 105 E 5000--> 105 E 5000 102 B 2000 104 D 4000 103 C 3000 101 A 1000--> 104 D 4000
Why is theta join required?
What is a natural join sql?
How delete a row in sql?
what is a record in a database ? : Sql dba
What are code pages ?