What is diff between bulk collect and forall

Answers were Sorted based on User's Feedback



What is diff between bulk collect and forall..

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.

Is This Answer Correct ?    21 Yes 1 No

What is diff between bulk collect and forall..

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

Is This Answer Correct ?    5 Yes 0 No

What is diff between bulk collect and forall..

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.

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

what is difference between "Primary key" and "Unique key"?

4 Answers   PreVator,


What is primary key and foreign key with example?

0 Answers  


how can you see all indexes defined for a table? : Sql dba

0 Answers  


7. Where would you look for errors from the database design?

1 Answers   Fintellix,


How many types of keys are there in sql?

0 Answers  






what is a composite primary key ? : Sql dba

0 Answers  


what is the difference between sql and t-sql? : Transact sql

0 Answers  


What does joining a thread mean?

0 Answers  


How does join work in sql?

0 Answers  


IF EMP HAS 2 ROWS,DEPT HAS 4 ROWS.WHATS THE RESULT OF SELECT * FROM EMP,DEPT;

1 Answers  


Name some usages of database trigger?

0 Answers  


Which clause of an UPDATE statement allows you to affect only certain rows of a table? 1. The WHERE clause 2. The SET clause 3. The ROWS AFFECTED clause 4. The ORDER BY clause

6 Answers   HCL,


Categories