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 |
there are 2 variables called x and y ,x contains 1,2 and y contains 3,4 we have to swap the values from x to y and y to x with out using dummy variables and it can be done only by using a single statement ? how?
what is inline view?
How many types of relationship are there?
What is sqlerrd?
Describe types of sql statements?
What packages(if any) has oracle provided for use by developers?
What is synonyms?
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
What does cursor do in sql?
What is the differnce between view and materialized view
Is pl sql useful?
We have a CURSOR then we need BULK COLLECT?