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 the difference between local variables and global variables?

600

---

What is scalar function?

564

---

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

511

---

What is the difference between microsoft sql and mysql?

504

---

How do I run a sql trace?

516

---

---

Is pl sql still used?

505

---

Can a trigger call a stored procedure?

532

---

What is difference between table and view?

518

---

what is primary key? : Sql dba

508

---

Is json a nosql?

535

---

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

664

---

What is package in pl sql with an examples?

542

---

Is sqlite free?

529

---

How much does sql certification cost?

542

---

Why we use cross join?

536

---