Database Reference
In-Depth Information
Figure 24.17
Splitting Results
Using a Selector-
type CASE
Statement.
24.7.2
Iteration or Repetition
In programming, loops are either FOR loops, WHILE loops, or UNTIL
loops:
FOR Loop
. Iterate through a known set of values.
WHILE Loop
. Iterate as long as a condition is true.
LOOP...END LOOP Construct
. A potentially infinite loop iterating
without a condition on the loop statement. This construct can be
used as an UNTIL loop (iterates until a condition is true) by placing
an EXIT WHEN clause just before the END LOOP statement.
FORALL Command
. The FORALL command is exclusive to PL/
SQL and is a collection iteration or looping command. It allows scan-
ning through the elements of a VARRAY, nested table, or associative
array.
There are improvements in Oracle Database 10
g
.
