11g下wmsys.wm_concat(group_lw)
9I下 select serv_number,substr(max(sys_connect_by_path(group_lw,';')),2) oid
from
(
select a.serv_number,a.group_lw,row_number () over(partition by a.serv_number order by a.group_lw) rn
from masakr.bb a
)
group by serv_number
start with rn=1
connect by rn-1=prior rn and serv_number=prior serv_number