wm_concat

select org_name,department,to_char(wm_concat(ebs_org_num)) from GHB.org_add_tmp  group by org_name,department ;