Answer / prabu t

Bulk collect:
*is a CLAUSE
*is used to fetch the records from the cursor.
Forall:
*is a STATEMENT
*is used to do dml operation of fetched records.

*The body of the FORALL statement is a single DML statement
-- an INSERT, UPDATE, or DELETE.

Answer / 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."

Answer / shweta singh

BULK COLLECT: SELECT statements that retrieve multiple rows with a single fetch, improving the speed of data retrieval

FORALL: INSERTs, UPDATEs, and DELETEs that use collections to change multiple rows of data very quickly.

what is data integrity

3 Answers   Fidelity, TCS,

---

How do I clear the screen in sql plus?

0 Answers  

---

which operator is used in query for pattern matching? : Sql dba

0 Answers  

---

Which is faster subquery or join?

0 Answers  

---

Are stored procedures faster than dynamic sql?

0 Answers  

---

Is sql microsoft?

0 Answers  

---

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

1 Answers  

---

A table has 150 records. How do you retrieve 100th row to 120th row from that table ?

21 Answers   IBM,

---

Is pl sql a scripting language?

0 Answers  

---

What does stand for in sql?

0 Answers  

---

Why is stored procedure faster than query?

0 Answers  

---

What are few of the schema objects that are created using PL/SQL?

0 Answers  

---