2020-12-09 Oracle sql 实现查询时将一个字符串按照“,“逗号分隔，返回分隔后的各个值

Oracle sql 实现查询时将一个字符串按照","逗号分隔，返回分隔后的各个值

SELECT DISTINCT REGEXP_SUBSTR ('A-1,B-2,C-3,D-4','[^,]+',1,LEVEL) as "result"
FROM DUAL
CONNECT BY REGEXP_SUBSTR ('A-1,B-2,C-3,D-4','[^,]+',1,LEVEL) IS NOT NULL
order by 1

select distinct  COMPANY_ID,BRANCH_ID 
from sales.emp_position_org_view a 
where COMPANY_ID in (
SELECT DISTINCT REGEXP_SUBSTR (ATTRIBUTE_VALUE,'[^,]+',1,LEVEL) as "result"
FROM (select ATTRIBUTE_VALUE from sales.attribute_info  where ATTRIBUTE_ID='SyncUserConfig' )
CONNECT BY REGEXP_SUBSTR (ATTRIBUTE_VALUE,'[^,]+',1,LEVEL) IS NOT NULL
)
or  BRANCH_ID in (
SELECT DISTINCT REGEXP_SUBSTR (ATTRIBUTE_VALUE,'[^,]+',1,LEVEL) as "result"
FROM (select ATTRIBUTE_VALUE from sales.attribute_info  where ATTRIBUTE_ID='SyncUserConfig' )
CONNECT BY REGEXP_SUBSTR (ATTRIBUTE_VALUE,'[^,]+',1,LEVEL) IS NOT NULL
)