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 an inner and outer join?

1001

---

What is primary key in db?

993

---

How do you know if a relationship is 2nf?

926

---

what are date and time functions in mysql? : Sql dba

966

---

How do you rename a table in sql?

1089

---

tell me about various levels of constraint. : Sql dba

1027

---

what is data integrity? : Sql dba

1021

---

Is it possible to read/write files to-and-from PL/SQL?

1085

---

What is meant by user defined function?

1028

---

Can we insert in sql function?

1068

---

What is bitemporal narrowing?

1289

---

what is try_catch block in procedure

1725

---

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

1027

---

Can we create table inside stored procedure?

941

---

Why we use joins in sql?

968

---