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
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
What is oracle sid?
How to assign values to data fields in record variables?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What happens to the current transaction if the session is ended?
How can Oracle users be audited?
Please explain compound trigger in oracle?
What is object data modeling?
How to install oracle odbc drivers?
Why do you use stored procedures and state some of its disadvantages?
How many file formats are supported to export data?
How to set up autotrace for a user account?
What are the restrictions in a oracle read only transaction?
How to manage transaction isolation level?
How to create an oracle database manually?
