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 sql dialect?

1172


What does a pl/sql package consist of?

1013


what is innodb? : Sql dba

1163


What is error ora-12154: tns:could not resolve the connect identifier specified?

1117


what are local and global variables and their differences? : Sql dba

1131


What is a temp table?

1070


what is the difference between join and union? : Sql dba

1195


how to include numeric values in sql statements? : Sql dba

1145


Why truncate is used in sql?

1041


Explain the commit statement.

1213


What is the use of sql trace?

1001


What is rtm stands for?

1172


How does rowid help in running a query faster?

1473


What is a pragma statement?

1332


What are all the common sql functions?

1082