oracle 两行数据合并成一行_Oracle查询多行数据合并成一行数据

例如：

select base_id, translate (ltrim (text1, '/'), '*/', '*,') xmmc,translate (ltrim (text2, '/'), '*/', '*,') xmid

FROM (SELECT ROW_NUMBER ()

OVER (PARTITION BY base_id ORDER BY base_id, lvl DESC)

rn,

base_id,

text1,text2

FROM ( SELECT base_id,

LEVEL lvl,

sys_connect_by_path (info_name, '/') text1,sys_connect_by_path (info_id, '/') text2

FROM ( SELECT base_id,

info_name,info_id,

ROW_NUMBER ()

OVER (PARTITION BY base_id

ORDER BY base_id, info_name)

x

FROM base_relation

ORDER BY base_id, info_name) a

CONNECT BY base_id = PRIOR base_id

= PRIOR x))

ORDER BY base_id;

查询结果：

SQL分析：