在Oracle Magazine (现在在线为On Cursor FOR Loops)的一篇旧文章中,Steven Feuerstein展示了使用bulk collect对显式cursor for loops进行优化(在线文章中的清单4): DECLARE
CURSOR employees_cur is SELECT * FROM employees;
TYPE employee_tt IS TABLE OF employees_cur%ROWTYPE INDEX BY PLS_INTEGER;
l_employees employee_tt;
BEGIN
OPEN em