oracle 合并字段

select kg.*, kgunit.ms_time from tb_kg kg left join tb_kg_unit kgunit on kg.kg_id = kgunit.kg_id
where kg.kg_biaozhi = '否' order by kg.kgrole asc, kg.kg_id asc;

两表联合查询查到如下结果，将 kg_name相同的 ms_time合并到一个字段，该如何操作？

想要的效果图如下：

需要将语句改成

select kg_id,kgrole,kg_name, wm_concat(to_char(ms_time)) from (select kg.*, kgunit.ms_time from tb_kg kg left join tb_kg_unit kgunit 
on kg.kg_id = kgunit.kg_id where kg.kg_biaozhi = '否') group by kg_id,kgrole,kg_name;

*函数wm_concat 出现乱码时需要加 to_char()

以下为不加tochar的结果