create or replace type t_r as object
( n_mon   number,
  cnt_mon number
);
/

create or replace type t_t as table of t_r;
/
col t format a70
col dep_name format a25

select d.dep_name,
       cast(multiset( select e.emp_id, e.job_id
                      from emps e
                      where d.dep_id = e.dep_id
                            and
                            rownum <  5 ) as t_t) t
from deps d
where rownum <  10 
;

DEP_NAME		  T(N_MON, CNT_MON)
 ------------------------- ----------------------------------------------------------------------
 
Main department 	  T_T(T_R( 1 ,  1 ))
department #  11  	  T_T(T_R( 1676 ,  8 ), T_R( 12110 ,  4 ), T_R( 12231 ,  23 ), T_R( 12252 ,  9 ))
department #  12  	  T_T(T_R( 1565 ,  34 ), T_R( 11704 ,  8 ), T_R( 12703 ,  20 ), T_R( 12746 ,  35 ))
department #  13  	  T_T(T_R( 920 ,  19 ), T_R( 12378 ,  16 ), T_R( 12525 ,  11 ), T_R( 839 ,  35 ))
department #  14  	  T_T(T_R( 1285 ,  9 ), T_R( 1337 ,  17 ), T_R( 1437 ,  40 ), T_R( 11956 ,  18 ))
department #  15  	  T_T(T_R( 1450 ,  21 ), T_R( 1712 ,  26 ), T_R( 11748 ,  33 ), T_R( 12406 ,  5 ))
department #  16  	  T_T(T_R( 1680 ,  20 ), T_R( 12131 ,  36 ), T_R( 12429 ,  6 ), T_R( 667 ,  10 ))
department #  17  	  T_T(T_R( 1582 ,  4 ), T_R( 12395 ,  18 ), T_R( 12744 ,  18 ), T_R( 13128 ,  38 ))
department #  18  	  T_T(T_R( 944 ,  35 ), T_R( 11718 ,  3 ), T_R( 12403 ,  16 ), T_R( 212 ,  6 ))

 9  rows selected.