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
Why is oracle so popular?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
Can a parameter be passed to a cursor?
What are the limitations oracle database 10g xe?
What is a nested table and how is it different from a normal table?
Explain the use of full option in exp command.
How to use an explicit cursor without open statements?
How does Oracle guarantee data integrity of data changes?
How do I find the database name in oracle?
What do you mean by cdb and pdb in oracle 12c?
How to start your 10g xe server from command line?
How to turn on or off recycle bin for the instance?
Explain the use of parfile option in exp command.
What are the oracle built-in data types?
Whether any commands are used for months calculation? If so, what are they?
