mysql数据库:group_concat(列名,'分割符符号')
select group_concat(NAME, ';') from OFFICE_WORK_LOG_VIEW where WORK_LOG_ID=owl.ID;
结果:weiwei;zhanghui;zhouqiangzhi
oracle数据库:oracle 10g以上可以用wm_concat(列名)
select wm_concat(NAME) from OFFICE_WORK_LOG_VIEW where WORK_LOG_ID=owl.ID;
结果:weiwei,zhanghui,zhouqiangzhi
select WMSYS.WM_CONCAT(NAME) from OFFICE_WORK_LOG_VIEW where WORK_LOG_ID=owl.ID;
结果:weiwei,zhanghui,zhouqiang