想实现以下功能
目前SQL如下
create table test0514
(
name varchar2(500),
score varchar2(500)
)
insert into test0514 values('张三');
insert into test0514 values('张三');
insert into test0514 values('张三');
insert into test0514 values('张三');
insert into test0514 values('李四');
insert into test0514 values('王五');
insert into test0514 values('赵六');
insert into test0514 values('戴七');
insert into test0514 values('鬼八');
select replace(wm_concat(distinct decode(name,'张三','钢铁侠','李四','美国队长','王五','绿巨人','赵六','蜘蛛侠','戴七','黑寡妇','鬼八','猩红女巫','老十','sb')),',','+') from test0514 order by rownum
无法实现排序功能,请教各位大神如何实现!!在线等!!!