【无标题】

sql一个字符串里面有多个以逗号分割的字符串，将其分割出来单独进行查询

SELECT CASE WHEN COUNT(1)>0 THEN 0 ELSE 1 END FROM MA_QLR WHERE BDCDYH in (SELECT distinct REGEXP_SUBSTR(:bdcdyh, '[^,]+', 1, LEVEL) VALUE
  FROM MA_QLR
CONNECT BY LEVEL <= REGEXP_COUNT(:bdcdyh, '[^,]+')) AND QSZT = '1' AND BDCQZH IS NOT NULL