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 forall Statement ?

Answer Posted / ruchi

The keyword FORALL lets you run multiple DML statements
very efficiently. It can only repeat a single DML
statement, unlike a general-purpose FOR loop.

The FORALL statement issues a series of INSERT, UPDATE, or
DELETE statements, usually much faster than an equivalent
FOR loop. It requires some setup code, because each
iteration of the loop must use values from one or more
collections in its VALUES or WHERE clauses.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain how are indexes update?

1033


Why we use bulk collect in oracle?

984


What is the sid in oracle?

913


What is java oracle used for?

981


What is oracle rownum?

897


What are the logical operations?

1073


How many types of cluster table in Oracle?

1000


what is the scripts in data base?

2093


Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

2010


Explain integrity constraint?

1120


How many data types are supported?

1037


Explain alias?

1088


How to change user password in oracle?

981


What is the difference between a hot backup and a cold backup in oracle?

970


I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

2411