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 “go” in t-sql? : Transact sql

1058


how to create a new table in mysql? : Sql dba

946


how can we destroy the session, how can we unset the variable of a session? : Sql dba

953


how to use regular expression in pattern match conditions? : Sql dba

981


Is primary key a clustered index?

930


how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

911


what is datawarehouse? : Sql dba

963


In a distributed database system, can we execute two queries simultaneously?

1015


Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

1129


Does pl sql work in mysql?

935


Does view contain data?

993


What is multiple partition?

932


How do you write an inner join query?

905


What is the need of merge statement?

996


What is crud stand for?

944