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
How to call a stored function with parameters?
Explain about functional dependency and its relation with table design?
What is the fastest query method to fetch data from the table?
How to calculate date and time differences in oracle?
How to create a new user account in oracle?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
Does oracle database need java?
What is a server parameter file in oracle?
In what script is snap$ created? In what script is the scott/tiger schema created?
What is oracle open database communication (odbc)?
Why do we use coalesce function in oracle?
How to convert a date to char in oracle? Give one example.
How to drop a stored procedure in oracle?
What is a lookup table in oracle?
what is reindexing?
