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 happens when a trigger is associated to a view?

840

---

How many sectors are in a partition?

1031

---

What are the different types of constraints?

1072

---

What is the difference between pl and sql?

1035

---

Is it possible to sort a column using a column alias?

991

---

Is join and inner join the same?

940

---

how many sql ddl commands are supported by 'mysql'? : Sql dba

955

---

what is rdbms? : Sql dba

959

---

what is blob? : Sql dba

1055

---

What is the difference between rename and alias?

1267

---

What is sql analyzer?

958

---

The in operator may be used if you know the exact value you want to return for at least one of the columns.

1026

---

What is program debugging?

1129

---

What is the most restrictive isolation level? : Transact sql

1024

---

How do you clear the screen in sql?

1010

---