Oracle列转行函数vm_concat使用

<select id="listAllocatedHandlerInfo" resultType="AllocationHandlerInfoVo">
		select to_char(wm_concat(bs.user_name || '(' || bs.user_code || ')')) allocatedHandler,
		       sd.step_name approveStep
		from t_flow_step fs
		left join t_user bs
			on fh.handler = bs.user_code
		left join t_step_define sd
		    on fs.step_id = sd.step_id
		group by sd.step_name
	</select>

$.ajax({
				url:".../loadAllocatedHandlerInfo.do",
				dataType:"json",
				data:{
					flowId:$("#flowId").val()
				},
				async:false,
				success:function(result){
					//构建一下表格数据
					var data;
					if (result !="" && result != undefined) {
						data = eval(result);
					}
					var table = "<tr><th>环节名称</th>"+
					"<th>经办人</th>"+
					"<th>操作</th></tr>";
					for (var i in data) {
						table += "<tr>";
						table += "<td>"+data[i].approveStep+"</td>";
						table += "<td>"+data[i].allocatedHandler+"</td>";
						table += "<td><a href='javascript:pageOption.toMemListPage(\""+data[i].flowStepCode+"\");'>配置经办人</a></td>";
						table += "</tr>";
					}
					$("#allocatedHandlerInfo").append(table);
				}
			});

select vm_concat(a) from A group by id

select replace(vm_concat(a),',''|') from A group by id

select to_char(vm_concat(a)) from A group by id

select to_char(nvl2(b,vm_concat(a||'('||b||')'), '') from A group by id