Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is diff between bulk collect and forall

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is left join and outer join same?

1073


What is cte?

986


Why do we use joins?

1043


what is rdbms? : Sql dba

1018


Is primary key clustered or nonclustered?

1021


Are sql connections encrypted?

1032


Why is a trigger used?

946


What is sql architecture?

1056


What is on delete set null?

1092


Is it possible to include an insert statement on the same table to which the trigger is assigned?

1022


What does the hierarchical profiler does?

1062


What is the purpose of my sql?

953


explain access control lists. : Sql dba

1003


What's the difference between inner join and left join?

1002


What is the difference between distinct and unique in sql?

953