Answer Posted / prabhudatta barick

#"The keywords BULK COLLECT tell the SQL engine to bulk-bind output collections before returning them to the PL/SQL engine.
#You can use these keywords in the SELECT INTO, FETCH INTO, and RETURNING INTO clauses. Here is the syntax:

... BULK COLLECT INTO collection_name[, collection_name] ..."

#"The keyword FORALL instructs the PL/SQL engine to bulk-bind input collections before sending them to the SQL engine.
Although the FORALL statement contains an iteration scheme, it is not a FOR loop. Its syntax follows:

FORALL index IN lower_bound..upper_bound
sql_statement;

The index can be referenced only within the FORALL statement and only as a collection subscript.
The SQL statement must be an INSERT, UPDATE, or DELETE statement that references collection elements. And, the bounds must specify a valid range of consecutive index numbers.
The SQL engine executes the SQL statement once for each index number in the range."

What is not equal in sql?

1116

---

Is ms sql is free?

1020

---

What are sql indexes?

997

---

What is t-sql? : Transact sql

982

---

What is the usage of sql functions?

1144

---

Explain the components of sql?

1056

---

How do I install microsoft sql?

1049

---

what is the difference between truncate and drop statements? : Sql dba

1116

---

What is the maximum number of rows in sql table?

1025

---

Which sql statement is used to delete data from a database?

954

---

How do I run a sql script?

1144

---

what is the difference between nested subquery and correlated subquery?

1052

---

When is a declare statement required?

1136

---

Explain the commit statement.

1153

---

What is cte sql?

988

---