I have a CURSOR then why we need BULK COLLECT again?



I have a CURSOR then why we need BULK COLLECT again?..

Answer / 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

More SQL PLSQL Interview Questions

How to count the no of records of a table without using COUNT function?

11 Answers   TCS, Tesco,


Is microsoft sql free?

0 Answers  


What is the difference between a procedure and a function?

0 Answers  


How do I run a script in sql developer?

0 Answers  


What does truncate mean in sql?

0 Answers  






List out the acid properties and explain?

0 Answers  


Write a sql query to convert all character to uppercase after hypen.

0 Answers  


Does inner join return duplicate rows?

0 Answers  


define sql insert statement ? : Sql dba

0 Answers  


Can a table have two primary keys?

44 Answers   HCL, MetaCube,


What is the difference between sql and isql*plus?

0 Answers  


What is sql*loader and what is it used for? : aql loader

0 Answers  


Categories