Oracle 分割字符查询
时间:2022-03-10 17:52
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', ',', '')));
Oracle 分割字符查询,布布扣,bubuko.com