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 program debugging?

1334

---

Explain how exception handling is done in advance pl/sql?

1043

---

Is primary key is clustered index?

1039

---

How many triggers can be applied to a table?

1120

---

how can we know the number of days between two given dates using mysql? : Sql dba

1080

---

what is blob? : Sql dba

1215

---

What is an exception in PL/SQL? What are the two types of exceptions?

1391

---

What is rtm stands for?

1168

---

What is denormalization in a database?

1103

---

What is the difference between a primary key and a unique key?

1101

---

How to run pl/sql statements in sql*plus?

1129

---

What is the difference between left outer join and left join?

1032

---

what is datawarehouse? : Sql dba

1059

---

What is a native sql query?

1164

---

Explain what is sql*plus?

1193

---