PROCEDURE proc_02 IS
/*create table demo (id number(6) primary key ,
name varchar2(10));*/
TYPE id_table_type IS TABLE OF NUMBER(6) INDEX BY BINARY_INTEGER;
TYPE name_table_type IS TABLE OF VARCHAR2(10) INDEX BY BINARY_INTEGER;
id_table id_table_type;
name_table name_table_type;
--bulk collect
TYPE emp_table_type IS TABLE OF emp%ROWTYPE INDEX BY BINARY_INTEGER;
emp_table emp_table_type;
BEGIN
FOR i IN 1 .. 100 LOOP
id_table(i) := i;
name_table(i) := 'Name' || i;
END LOOP;
--批量绑定
FORALL i IN 1 .. id_table.count
INSERT INTO demo VALUES (id_table(i), name_table(i));
--批量绑定集合
SELECT * BULK COLLECT INTO emp_table FROM emp;
FOR i IN 1 .. emp_table.count LOOP
dbms_output.put_line(emp_table(i).ename);
END LOOP;
--DML中使用
DELETE FROM emp
WHERE emp.empno = '7788'
RETURNING emp.ename BULK COLLECT INTO name_table;
dbms_output.put_line('DELETE:' || name_table(1));
END;