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
How to divide query output into groups in oracle?
What are named parameters?
What do you understand by a database object? Can you list a few of them?
How to write date and time interval literals in oracle?
What are advantages of dateset in datastage?
How to get a list of all background sessions in the database?
What is snapshot is too old? Give and example for better understand.
What are the differences between interval year to month and interval day to second?
How to convert characters to times in oracle?
Briefly explain what is literal? Give an example where it can be used?
What is the difference between post-database commit and post-form commit?
What are the uses of a database trigger?
What is an Oracle index?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
How to turn on or off recycle bin for the session?
