What is forall Statement ?
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 does ROLLBACK do ?
Can select statements be used on views in oracle?
Will you be able to store pictures in the database?
How to create lov dynamically at runtime & attach to text field?
What is Data Dictionary Cache in Oracle?
What are the uses of linked server and explain it in detail?
When do we use group by clause in a sql query?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
What is an anonymous block?
Differentiate the standard purchase order,Blanket purchase agreement,Contract purchase agreement,Planned purchase order?
What is a package in oracle?
What is ASM (Automatic Storage Management) in Oracle?