oracle;一个字段切分对应再组合

fanjixiang

T表a字段：x,xx,xxx

D表对应列表k:v：x:1；xx:2；xxx:3；
获取字段：1,2,3
初步实现：

1. select listagg(v, ',') within group ( order by id)
   
2. from (
   
3.         select k, v, id
   
4.         from (
   
5.                  select regexp_substr(a, '[^,]+', 1, ROWNUM) key, id
   
6.                  from (select id, a from OARW_PROJECT_CONFIG where id = ?)
   
7.                  connect by ROWNUM <= length(a) - length(regexp_replace(a, ',', '')) + 1
   
8.        ) t1
   
9.        left join D on k = key
   
10.      ) t2

复制代码