数据库中多行转一行

Oracle数据库：使用listagg函数

select 
        LISTAGG(TO_CHAR(a.changesit_cate),'/') WITHIN GROUP(ORDER BY changesit_cate) AS             
        changesit_cate,
        a.change_code
      from (
              select 
                    t.changesit_cate as changesit_cate,
                    t.change_code
                      from (
                                select (
                                            select max(a.dic_name)
                                               from pm_t_dic a
                                               where a.dic_code = s.changesit_cate
                                      ) as changesit_cate,
                                         s.change_befplan,
                                         s.change_aftplan,
                                         s.change_code
                                  from PM_T_PROCHANGE_STRU s
                                  where s.dbtype = 'dt_pm_prochangestru_dbtype_01'
                           ) t
                      where t.changesit_cate is not null
           ) a  
            group by a.change_code

表内容：

预期结果：

Mysql 数据库：