What is forall Statement ?
- 2 Answers
- 5430 Views
- Thermotech, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / ron
used in pl/sql block, to do bulk operations; to speed up
operations such as fetch and other dml statements.
| Is This Answer Correct ? | 2 Yes | 0 No |
How to define an anonymous procedure with variables?
Why do we need oracle client?
Which Oracle App Is Most Popular One ?
What do you understand by a database object?
What happens to the data files if a tablespace is dropped?
why can't we assign not null constraint as table level constraint
How to call a stored function with parameters?
Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint ?
How to experiment a data lock in oracle?
What is STATSPACK tool?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
Indexes in oracle ?
3 Answers Keane India Ltd, L&T,
Oracle General 
