Como pegar o resultado de um cursor em um select?

[chduarteParticipante]

Sim:

SQL> begin
for crs1 in (select username from dba_users) loop
for crs2 in (Select count(1) total from dba_objects where owner = crs1.username) loop
dbms_output.put_line(‘Total de objetos do usuario ‘||crs1.username||’: ‘||crs2.total);
end loop;
end loop;
end;
/

[]