Listing 15 illustrates the use of BULK COLLECT.
清单15说明了BULK COLLECT的使用。
Similarly, when a FETCH statement includes the BULK COLLECT clause, the variable used in the FETCH must be an array.
同样，FETCH语句包括BULK COLLECT子句时，用于 FETCH的变量必须是阵列。
BULK COLLECT is not a statement on its own, but an optional clause that can be applied to SELECT INTO and FETCH statements.
BULK COLLECT自身不是语句，而是可用于SELECTINTO和fetch语句的可选子句。
When the BULK COLLECT clause is included, the statement can return multiple rows; the variable in the INTO clause must be an array, and each row is stored in an array element.
在包括BULK COLLECT子句后，该语句可返回多行；INTO 子句中的变量必须是阵列，且每一行存储在一个阵列元素中。
DB2 doesn't provide direct equivalents to these operations, but the most common USES of FORALL and BULK COLLECT can be efficiently mapped to statements involving UNNEST and ARRAY_AGG, respectively.
DB 2不提供这些操作的直接等效操作，但是FORALL和BULK COLLECT的最常见使用可有效地分别映射到涉及UNNEST和ARRAY_AGG的语句。
Another is the incentive scheme they operate for their agents, the bulk of whose earnings is based on how much they collect.
另一个优势是针对贷款经纪人所设立的激励机制，这些经纪人的大部分收益取决于他们所收还款的金额（佣金）。
Tobacco bulk curing barn was designed and developed using heat pump principle which can collect thermal in the air.
根据热泵原理设计开发了收集空气中热能的烟叶烤房。
Tobacco bulk curing barn was designed and developed using heat pump principle which can collect thermal in the air.
根据热泵原理设计开发了收集空气中热能的烟叶烤房。
应用推荐