Interested to Buy Any Domain ? << Click Here >> for more details...
What is forall Statement ?
- 2 Answers
- 5970 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 |
What to do if the startbd.bat failed to start the xe instance?
2. Display the post code and the total number of purchase orders placed with creditors in that post code.
What is the difference between Sleep and Wait? (Java)
I need to get the values of the previous quarter.how to do this?eg: if my cuurent month is may i need to get the datas of the month jan,feb,march.Can it be done in oracle.I tried with date function q but for the month jan its not retriving the previous quarter(oct-dec).how to solve this.plpz anyone help me?
"primary key=unique+null" is equal,reson?not,reason?
What is a trigger and what are its types?
How to define an oracle sub procedure?
How to drop an index?
How do I reset a sequence in oracle?
16. Display the order number, order line number and the shipping date. If the shipping date is null, display the string <not shipped yet>.
Does facebook use oracle?
What are the Limitations of a CHECK Constraint ?
Oracle General 
