Interested to Buy Any Domain ? << Click Here >> for more details...
What is forall Statement ?
- 2 Answers
- 5857 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 |
Why do you create or replace procedures rather that drop and recreate.
How to define an anonymous block?
What is the difference between 10g OEM and 11g OEM?
What are inner join and outer join?
Which is better Oracle or MS SQL? Why?
You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.
What is an oracle data file?
How translate command is different from replace?
What is the use of Redo Log Information ?
find the second highest salary of the emp table
What is the difference between substr & instr functions?
How does the on-delete-cascade statement work?
Oracle General 
