What is forall Statement ?
- 2 Answers
- 5196 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 |
I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.
9. Display the client name and order date for all orders using the JOIN . . . USING method.
Explain temporal data types in oracle
Where are the settings stored for each instance in oracle?
How do I reset a sequence in oracle?
In Exception handling if we are using the when others first then what happens . whether it will show the compiler error
i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?
What are the differences between primary key and unique key?
How to change system global area (sga) in oracle?
Is insert autocommit in oracle?
What is recovery manager(rman) backup in Oracle?
What is Private Database Link ?
Oracle General 
