Interested to Buy Any Domain ? << Click Here >> for more details...
What is forall Statement ?
- 2 Answers
- 5952 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 |
Hello All, Could any one provide me FAQs/interview questions on oracle PL/SQL
How to turn on or off recycle bin for the session?
What is Index Cluster ?
How to Identify the previously inserted/updated records in already populated table.
Which dictionary tables and/or views would you look at to diagnose a locking issue?
Give the various exception types.
what is the use of ondelete cascade?
What are the general rules on data consistency?
What is dynamic proxy?
What is Segment Advisor in Oracle?
Explain database link?
How to get maxsal , minsal, ename department wise in single query
Oracle General 
