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
Explain how are indexes update?
Why we use bulk collect in oracle?
What is the sid in oracle?
What is java oracle used for?
What is oracle rownum?
What are the logical operations?
How many types of cluster table in Oracle?
what is the scripts in data base?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
Explain integrity constraint?
How many data types are supported?
Explain alias?
How to change user password in oracle?
What is the difference between a hot backup and a cold backup in oracle?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?