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."

table - new_no old_no 2345 1234 3456 2345 5678 4567 output sud be -new_no 1234 2345 3456 4567 5678

2 Answers  

---

what is sql.

7 Answers   Ericsson, Hewitt,

---

Is inner join same as self join?

0 Answers  

---

What is a heap in sql?

0 Answers  

---

What is an implicit commit?

0 Answers  

---

what is the purpose of update command in oracle?

7 Answers   MBT,

---

what is data integrity

3 Answers   Fidelity, TCS,

---

What is an emotional trigger?

0 Answers  

---

Does sql profiler affect performance?

0 Answers  

---

Write an sql query to select all records from the table?

0 Answers  

---

what are null values? : Sql dba

0 Answers  

---

What is dcl in sql?

0 Answers  

---