oracle ÐÐתÁк¯Êý

name desc username
ͬÊ sss ÕÅÈý
ͬÊ sss ÕÅËÄ

ͬÊ sss ÕÅÎå
ÅóÓÑ aaa name

²éѯ½á¹û name desc user_name
ͬÊ .. ÕÅÈý,ÕÅËÄ,ÕÅÎå
ÅóÓÑ .. name

select name,wmsys.wm_concat(user_name) from table group by name;