oracle 字符串拼接

Question

oracle 字符串拼接

Answer 1

select t1.b || '-' || t2.bfrom (select a, b from A where d = 1) t1,(select a, replace(wm_concat(c), ',', '-') bfrom Astart with d = 1connect by b = prior cgroup by a) t2where t1.a = t2.a