论坛 › Oracle运维 › oracle学习总结三（bulk collect用法）

luobo2ni 发表于 2018-9-22 12:26:54

oracle学习总结三（bulk collect用法）

CREATE TABLE emp2 AS SELECT * FROM employees;　　DECLARE
　　TYPE NumList IS TABLE OF employees.employee_id%TYPE;
　　enums NumList;
　　TYPE NameList IS TABLE OF employees.last_name%TYPE;
　　names NameList;
　　BEGIN
　　DELETE FROM emp2 WHERE department_id = 30
　　RETURNING employee_id, last_name BULK COLLECT INTO enums, names;
　　dbms_output.put_line('Deleted ' || SQL%ROWCOUNT || ' rows:');
　　FOR i IN enums.FIRST .. enums.LAST
　　LOOP
　　dbms_output.put_line('Employee #' || enums(i) || ': ' || names(i));
　　END LOOP;
　　END;
　　/
　　DROP TABLE emp2;

查看完整版本: oracle学习总结三（bulk collect用法）