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 are the different types of failures that occur in Oracle database?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
What are the original export and import utilities?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
Briefly explain what is literal? Give an example where it can be used?
How to define a cusotmer as a supplier in ORACLE R12
How would you best determine why your MVIEW couldnt FAST REFRESH?
What is the difference between pre-select and pre-query?
How do we create privileges in oracle?
What is an external table?
What is the difference between hot backup and cold backup in oracle?
How to put more than 1000 values into an oracle in clause?
What is max rowid in oracle?
How to define an oracle cursor variable?
What are the built-in functions used for sending Parameters to forms ?
