BULK COLLECT(成批聚合类型)和数组集合type类型is table of 表%rowtype index by binary_integer用法笔记。

例1: 批量查询项目资金账户号为 "320001054663"的房屋账户信息并把它们打印出来 .

DECLARE
TYPE acct_table_type IS TABLE OF my_acct%ROWTYPE INDEX BY BINARY_INTEGER;
v_acct_table acct_table_type;
BEGIN
SELECT * BULK COLLECT INTO v_acct_table FROM my_acct WHERE parent_fund='320001054663';
FOR i IN 1..v_acct_table.COUNT LOOP
---循环打印
dbms_output.put_line('ACCT:'//v_acct_table(i).fund// ','//v_acct_table(i).bal//','//v_acct_table(i).real_nmbr);..