What is diff between bulk collect and forall

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between inner join and left join?

547


What type of join is sql join?

531


Explain what is sql?

610


explain primary keys and auto increment fields in mysql : sql dba

530


What is a nested table in word?

534






Why do we use sqlite?

533


What is input buffer in sql*plus?

640


What is orm in sql?

537


Why use truncate instead of delete?

546


What is the sql*loader? : aql loader

589


Is and as keyword in pl sql?

511


What is a subquery in sql?

511


What is mutating sql table?

611


Which normal form is best?

515


Can you have more than one trigger on a table?

532