Interested to Buy Any Domain ? << Click Here >> for more details...
What is forall Statement ?
- 2 Answers
- 5911 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 |
Difference between hot backup vs. Cold backup?
How to view all columns in an existing table?
Where are the settings stored for each instance in oracle?
What are the restrictions in a oracle read only transaction?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
How to assign a table row to a record variable?
A and B are tables. x is a column. Then What is difference between A.x = B.x(+) and A.x = B.x ?
How do I spool to a csv formatted file using sqlplus?
What are the differences between number and binary_float in oracle?
What are the uses of a database trigger?
what is the difference between oracle enterprise edition and oracle express edition?
What is save point in oracle database?
Oracle General 
