wm_concat
select to_char(wm_concat(ssss)) from (
select replace(C_CELL_CONTENT ,'=$','') ssss ,rownum ss from (
select distinct C_CELL_CONTENT,1 sss from T_F_RC_REP_TBCELL where C_CELL_CONTENT like '=$%"%'))
splitstr和wm_concat()的用法
select distinct * from table( splitstr((select to_char(wm_concat(ssss)) from (
select replace(C_CELL_CONTENT ,'=$','') ssss ,rownum ss from (
select distinct C_CELL_CONTENT,1 sss from T_F_RC_REP_TBCELL where C_CELL_CONTENT like '=$%"%'
) t )) ,'"') );