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...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

What is diff between bulk collect and forall

Question Posted / prabu t

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

How many aggregate functions are available there in sql?

965

Which is better join or inner query?

1014

What is scalar function?

1032

What does trigger mean in slang?

1032

What are keys in sql?

978

What is difference sql and mysql?

966

What is pl sql and why it is used for?

1098

Is sql better than excel?

1116

What is autocommit sql?

967

how to calculate expressions with sql statements? : Sql dba

1021

What are the advantages of stored procedure?

988

What does over partition by mean in sql?

957

How do I view stored procedures?

957

Explain the purpose of %type and %rowtype data types with the example?

973

how to fetch common records from two tables? : Sql dba

1155