原表如下
select * from hs_acct.custattach a where a.client_id='888827395';
将列拆分成多行的语句
select
*
from
(
----将列拆分成多行的语句
select distinct a.client_id
,REGEXP_SUBSTR(a.en_branch_no, '[^,]+', 1, L) AS en_branch_no
from hs_acct.custattach a, (SELECT LEVEL L FROM DUAL CONNECT BY LEVEL <= 10000) b
WHERE b.L(+) <= LENGTH(a.en_branch_no) - LENGTH(REPLACE(a.en_branch_no, ',')) + 1
) tt
where trim(tt.en_branch_no) is not null
and tt.client_id='888827395';
![[SQL注入] 逗号拦截绕过](https://www.kunjuke.com/file/css/thumb/5.jpg/280-180.jpg)
![[原创]SQL表值函数:把用逗号分隔的字符串转换成表格数据](https://www.kunjuke.com/file/css/thumb/11.jpg/280-180.jpg)
