PL/SQL - Exemplo de utilização de Bulk Collect

declare

  type table_employee is table of employee%rowtype  index by binary_integer;
    
  cursor c_employee is
  select *
  from   employee
  order by last_name;

  v_table_employee table_employee;
        
begin
      
    open  c_employee;
    fetch c_employee bulk collect into v_table_employee;
    close c_employee;

    for x in v_table_employee.first..v_table_employee.last loop
      dbms_output.put_line(v_table_employee(x).last_name||' '||v_table_employee(x).job_id||' '||v_table_employee(x).salary) ; 
    end loop;
    
end;