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 pls_integer in pl sql?

1157

---

Can we rollback truncate?

1050

---

What is difference between sql and mysql?

1194

---

What are different types of indexes?

1057

---

What programs use sql?

1087

---

What is secondary key?

987

---

Explain what is a subquery ?

1244

---

what is the difference between $message and $$message? : Sql dba

1039

---

What is primary key sql?

1110

---

Where is sql database stored?

1039

---

Can we use pl sql in sql server?

1136

---

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

1249

---

what is datawarehouse? : Sql dba

1066

---

what is 'mysqladmin' in mysql? : Sql dba

1073

---

what is a join? : Sql dba

1085

---