declare
  type name_salary_rt is record(
     name   varchar2(1000)
    ,salary number);

  type name_salary_aat is table of name_salary_rt index by pls_integer;

  l_employees name_salary_aat;
begin
  execute immediate q'[select first_name || ' ' || last_name, salary
           from employees
          order by salary desc]' bulk collect
    into l_employees;

  for indx in 1 .. l_employees.count loop
    dbms_output.put_line(l_employees(indx).name);
  end loop;
end;
/