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

What are analytic functions in sql?

1005

---

Can we use threading in pl/sql?

1017

---

What is the difference between the implicit and explicit cursors?

1033

---

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

978

---

What is an emotional trigger?

982

---

How to connect a sql*plus session to an oracle server?

1111

---

What is the use of double ampersand (&&) in sql queries? Give an example

1122

---

What are types of indexes in sql?

1061

---

What is cursor explain with example?

964

---

What is a full join?

956

---

Does pl sql work in mysql?

950

---

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7261

---

what is the difference between where clause and having clause? : Sql dba

979

---

what is collation? : Sql dba

1130

---

How do I run sql?

1148

---