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 is the quickest way to fetch the data from a table?
How many data types are supported?
What is the usage of merge statement?
How to use "for" statements in oracle?
Design database draw er diagram for a certain scenario ?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
How remove data files before opening a database?
What is the use of aggregate functions in oracle?
What is the difference between a user and a schema in oracle?
What are operators in oracle?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
Is oracle the best database?
What privilege is needed for a user to create tables in oracle?
What is meant by an index?
What happens to the current transaction if the session is ended?
