|
What is forall Statement? Explain with an example The FORALL binds input as a collection and sends them to the SQL engine for processing.
The FORALL statement issues a series of static or dynamic DML 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.
|
