substrc(arr.name, 1, 1)||' '||substrc(arr.patronymic, 1, 1)

||' . ' ||

select distinct p.account_number,
       LISTAGG (arr.last_name||' '||substrc(arr.name, 1, 1)||' '||substrc(arr.patronymic, 1, 1), ', ') 
                                          WITHIN GROUP (order by arr.last_name) over (partition by p.account_number)"ФИО"

select distinct  p.account_number,
       LISTAGG (arr.last_name||' '||substr(arr.name, 1, 1)||' '||substr(arr.patronymic, 1, 1), ', ') 
                                          WITHIN GROUP (order by arr.last_name) over (partition by p.account_number)"ФИО",
       r.name"Название региона", t.short_name||' '||c.name"город", e.short_name||' '||s.name"адрес",h.house_number"ном.дома", f.flat_number"номер квартиры",
                                  
(select count (*) from flat_citizen where p.account_number=flat_citizen.account_number and
                                          (p.close_date > to_date('01.12.2016', 'dd.mm.yyyy') or p.close_date is null) and
                                          (flat_citizen.date_end > to_date('01.12.2016', 'dd.mm.yyyy') or flat_citizen.date_end is null) and
                                          flat_citizen.date_begin < to_date('01.12.2016', 'dd.mm.yyyy'))"Кол. проживающих"                                         
                                       
from region r,
     cities c,
     street s,
     house h,
     personal_account p,
     flat f,
     street_type e,
     city_type t,
     (select l.account_number,z.last_name,z.name, z.patronymic from citizen z, flat_citizen l
     where l.citizen_id=z.id and l.main_tenant_flg='Y')arr 
where r.id=c.region_id and 
      c.id=s.cities_id and
      s.id=h.street_id and
      p.account_number=arr.account_number(+) and
      s.id= any 50 and  
      p.flat_id=f.id and
      h.id=f.house_id and
      t.id=c.city_type_id and
      e.id=s.type_id 
        
order by h.house_number, f.flat_number