Oracle 分割字符查询
select *
from view_psbaseinfo
where DECODE('410782001125,411100000043',
'',
NULL,
'410782001125,411100000043') IS NULL
or PSCODE in
(SELECT REGEXP_SUBSTR('410782001125,411100000043', '[^,]+', 1, LEVEL) AS PSCODE
FROM DUAL
CONNECT BY LEVEL <=
LENGTH('410782001125,411100000043') + 1 -
LENGTH(REPLACE('410782001125,411100000043', ',', '')));