SQL> with emp as (
  2               select 1 empid,'x' empnomini,'B' nominitype from dual union all
  3               select 1,'y','c' from dual union all
  4               select 2,'xx','B' from dual union all
  5               select 2,'yyyy','c' from dual
  6              )
  7  select  empid,
  8          max(case nominitype when 'B' then empnomini end) nominitype_b,
  9          max(case nominitype when 'c' then empnomini end) nominitype_c
 10    from  emp
 11    group by empid
 12  /

     EMPID NOMI NOMI
---------- ---- ----
         1 x    y
         2 xx   yyyy

SQL> 

select  empid,
        max(case nominitype when 'B' then empnomini end) nominitype_b,
        max(case nominitype when 'c' then empnomini end) nominitype_c
  from  emp
  group by empid
/

select  empid,
        max(case nominitype when 'B' then empnomini end) nominitype_b,
        max(case nominitype when 'c' then empnomini end) nominitype_c,
        .
        .
        .
        max(case nominitype when 'whatever' then empnomini end) nominitype_whatever
  from  emp
  group by empid
/