Interested to Buy Any Domain ? << Click Here >> for more details...
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
What do you understand by database schema and what does it hold?
What suggestions do you have to reduce the network traffic?
What are the differences between lov and list item?
How do I start tns listener?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
How to use existing values in update statements using oracle?
Calculate difference between 2 date / times in oracle sql?
What are named parameters?
What is java oracle used for?
How to connect to oracle using service name instead of sid?
What is a snapshot log?
Is rowid unique in oracle?
What is oracle in java?
How to update a table row with a record?
What is hot backup and logical backup?
