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', ',', '')));