"Instead of processing row-by-row sequentially, you can
process relational data set-by-set, without a cursor. For example,
to sum all payment rows with 100 or less balances and load it into
a table (named payment_100orless_bal in the following SQL
statement), you can use the following SQL statement. This single
SQL statement completely processes the rows that meet the
condition, all at once, as a set."