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

What is pl sql code?

1047


What are all the common sql functions?

1011


Sql technical questions

1272


What are the differences between implicit and explicit cursors?

1064


What is trigger explain with example?

1033


How to place comments in pl/sql?

1149


What is sql not null constraint?

1028


What does dml mean?

982


Explain what is sql?

1110


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

1028


What are inner outer left and right joins in sql?

1011


What is the maximum rows in csv?

920


What is difference between cursor and trigger?

1070


what are the drivers in mysql? : Sql dba

1015


How to select all records from the table?

1133