Interested to Buy Any Domain ? << Click Here >> for more details...
I have a CURSOR then why we need BULK COLLECT again?
- 1 Answers
- 7437 Views
- I also Faced
- E-Mail Answers
Answer Posted / priya
"PL/SQL sends SQL statements such as DML and queries to the
SQL engine for execution, and SQL returns the results to
PL/SQL. You can minimize the performance overhead of this
communication between PL/SQL and SQL by using the PL/SQL
features that are known collectively as bulk SQL.
The FORALL statement sends INSERT, UPDATE, or DELETE
statements in batches, rather than one at a time. The BULK
COLLECT clause brings back batches of results from SQL. If
the DML statement affects four or more database rows, bulk
SQL can improve performance considerably.
Bulk SQL uses PL/SQL collections to pass large amounts of
data back and forth in single operations. This process is
called bulk binding. If the collection has n elements, bulk
binding uses a single operation to perform the equivalent of
n SELECT INTO, INSERT, UPDATE, or DELETE statements. A query
that uses bulk binding can return any number of rows,
without requiring a FETCH statement for each one."
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
How many triggers can be applied to a table?
How can you fetch common records from two tables?
How do I run sql?
Can we use the cursor's to create the collection in PL/SQL?
Write a sql select query that only returns each name only once from a table?
Why stored procedure is faster than query?
Is grant a ddl statement?
What is the use of function "module procedure" in pl/sql?
What is the importance of sqlcode and sqlerrm?
what is the stuff function and how does it differ from the replace function? : Sql dba
What is orm in sql?
what is the difference between cluster and non cluster index? : Sql dba
What is cascade in sql?
What is pl/sql table? Why is it used?
What are the 3 types of behavioral triggers?
